I split the tables from my database because it is a multi-user database and put the split tables onto our network. There are 3 users all together and the network is very responsive. Ever since I split the tables out, the database is very slow. Forms take a few seconds to load and its just all together slow. Has anyone ever heard of this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Split tables, now DB is slow 1
- Thread starter risoam
- Start date
-
1
- #3
Check your settings under Tools, Options, General and make sure that 'Perform Name Autocorrect' is not selected.
This function scans the Db and looks for errors caused by renaming objects. When enabled, it has been known to slow down the performance of split db's on a network. - - - -
Bry
This function scans the Db and looks for errors caused by renaming objects. When enabled, it has been known to slow down the performance of split db's on a network. - - - -
Bry
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question