Recombine Split Database

  • Thread starter Thread starter Sam Stark
  • Start date Start date
S

Sam Stark

What's the easiest way to recombine a previously split database? I want to
test speed on the network split and combined.
 
Hi Sam,

The easiest way, in my opinion, is to open the back-end (data only) database. Then click on File
Get External Data > Import... Navigate to your front-end database. I recommend importing
Click to expand...
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
_____________________________________


What's the easiest way to recombine a previously split database? I want to
test speed on the network split and combined.
 
Sam Stark said:
What's the easiest way to recombine a previously split database? I want to
test speed on the network split and combined.
Click to expand...

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
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
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 said:
Sam Stark said:
What's the easiest way to recombine a previously split database? I want to
test speed on the network split and combined.
Click to expand...

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
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Click to expand...
 
Sam Stark said:
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.
Click to expand...

Correct. Although #2 does apply if you have an A2000 FE going against
an A97 BE.
I've always gotten around the LDB
issue by using an irrelevant bound table and invisible bound field on the
main switchboard.
Click to expand...

Yup, that works too.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top