| | |
|
|
|
Recombine Split Database |
|---|
| message from Sam Stark on 30 May 2004 |
What's the easiest way to recombine a previously split database? I want to
test speed on the network split and combined.
|
| Tony Toews replied to Sam Stark on 30 May 2004 |
Performance problems?
The three most common performance problems in Access 2000 are:
- LDB locking which a persistent recordset connection or an always
open bound form corrects (multiple users)
- sub datasheet Name property set to [Auto] should be [None]
- Track name AutoCorrect should be off
For more information on these, less likely causes, other tips and
links to MS KB articles visit my Access Performance FAQ page at
http://www.granite.ab.ca/access/performancefaq.htm
Tony
|
| Sam Stark replied to Tony Toews on 30 May 2004 |
Thanks. Just want to experiment after 3 years away from Access Development
and new networks XP Pro/Server 2003. I'm using 97. Don't believe
problems 2 & 3 apply to Access97. I've always gotten around the LDB
issue by using an irrelevant bound table and invisible bound field on the
main switchboard. By the way these Access newsgroups are as invaluable as
ever-great job of sharing.
"Tony Toews" <ttoews@telusplanet.net> wrote in message
news:v5bkb0pdl1qjpgm6q699bk23cmhf2rpef0@4ax.com...
|
| Tony Toews replied to Sam Stark on 30 May 2004 |
Correct. Although #2 does apply if you have an A2000 FE going against
an A97 BE.
Yup, that works too.
Tony
|
| Tom Wickerath replied to Sam Stark on 29 May 2004 |
Hi Sam,
The easiest way, in my opinion, is to open the back-end (data only) database. Then click on File
objects one group at a time, ie. all queries, then all forms, then all reports, etc. The Import
wizard will allow one to import all objects in one operation, but the folks at FMS
(www.fmsinc.com have stated that doing so can lead to problems.
That being said, you really do not want to run a multi-user database unsplit. Each user should
have a copy of the front-end on their own PC. Sharing the entire database is one of the number
one causes of Access database corruption.
Tom
_____________________________________
"Sam Stark" <sstark@carolina.rr.com> wrote in message
news:Mleuc.6478$2o.198404@twister.southeast.rr.com...
What's the easiest way to recombine a previously split database? I want to
test speed on the network split and combined.
|
|
Archived message: Recombine Split Database (Microsoft Access Database)
