Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
KnooKie
Aged Yak Warrior
623 Posts |
 Posted - 2005-02-05 : 10:24:54
|
| i have a small Access2003 database which needs to be put on a network for around 5 users and is not heavily transactional.The Access database has 2 parts1. the back-end (tables)2. the queries, forms etcthe tables are linked into the front-end.the backend part will reside on a server and the frontend part on each users machine.if the # of users and subsequent processor burden increases i am thinking it would be a good idea to upgrade the backend part to MSDE.1. Is the best way to do this (or only way?) to upsize the back-end part ?2. Can i then link the tables from there into the front-end as i would normally with SQL Server and access DBs ? Using a DSN.3. How do i interact with the MSDE part (not used MSDE before) for setting permissions/backups etc is there an interface ?advice welcomemany thanksPaul====Paul |
|
|
Andraax
Aged Yak Warrior
790 Posts |
|
|
sbt1
Yak Posting Veteran
89 Posts |
Posted - 2005-02-08 : 14:42:16
|
| One further bit of info - we use MSDE here with approx. 20 users. We've never seen the throttling mechanism affect anyone or anything. I think it only comes into play if you have more than 5 simultaneous very CPU-intensive queries going on. During normal usage we've never noticed a thing.Maybe it's our application's design- we connect to the database, get/set what we need, and immediately disconnect. |
 |
|
|
|
|
|
MSAccess > MSDE