Recombine Split Database

[Sam Stark]

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

 

[Tom Wickerath]

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

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.

 

[Tony Toews]

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

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

 

[Sam Stark]

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.

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

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

 

[Tony Toews]

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.

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.

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