Splitting an Access 2003 Database

[Vijay Chary]

Hi !!
Under what conditions should I split my database? How is it done
? What are the advantages of splitting my database ?

Thanks in advance !!



Vijay

 

[John W. Vinson]

Hi !!
Under what conditions should I split my database? How is it done
? What are the advantages of splitting my database ?

Check out Tony Toews' review of the subject:
http://www.granite.ab.ca/access/splitapp.htm

 

[Douglas J. Steele]

Any time you will have multiple users you should split. The exception
would be a rarely used file where more than one person uses it, but the
odds of them doing so at the same time is small.

(there is no harm in always splitting)

Heck, I split all my single user applications. What if you want to change
the functionality when there's already data there?

 

[David W. Fenton]

Any time you will have multiple users you should split. The
exception would be a rarely used file where more than one person
uses it, but the odds of them doing so at the same time is small.

(there is no harm in always splitting)

Another caveat:

All replicated apps should be split, since replication doesn't work
reliably over the long term with anything but data tables and
queries.

 

[Jeff Boyce]

Vijay

I'll offer one more voice on this ...

I develop most of my applications as single .mdb files, then split the
application for performance testing and "delivery".

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/