Splitting an Access 2003 Database

  • Thread starter Thread starter Vijay Chary
  • Start date Start date
V

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
 
Vijay said:
Hi !!
Under what conditions should I split my database? How is
it done ? What are the advantages of splitting my database ?

Thanks in advance !! :)
Click to expand...

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)
 
Rick Brandt said:
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)
Click to expand...

Heck, I split all my single user applications. What if you want to change
the functionality when there's already data there?
 
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)
Click to expand...

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.
 
Back
Top