Splitting an Access 2003 Database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vijay Chary - 27 May 2008 10:34 GMT

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

Reply to this Message

Rick Brandt - 27 May 2008 12:27 GMT

> Hi !!
> Under what conditions should I split my database? How is
> it done ? What are the advantages of splitting my database ?
>
> Thanks in advance !! :)

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)

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

Douglas J. Steele - 27 May 2008 22:35 GMT

>> Hi !!
>> Under what conditions should I split my database? How is
[quoted text clipped - 7 lines]
>
> (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?

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

Reply to this Message

David W. Fenton - 28 May 2008 02:02 GMT

>> Hi !!
>> Under what conditions should I split my database? How
[quoted text clipped - 8 lines]
>
> (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.

Signature

David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Reply to this Message

John W. Vinson - 27 May 2008 18:11 GMT

>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

Signature

John W. Vinson [MVP]

Reply to this Message

Jeff Boyce - 28 May 2008 13:26 GMT

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".

Signature

Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

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

> Hi !!
> Under what conditions should I split my database? How is it done
[quoted text clipped - 3 lines]
>
> Vijay

Reply to this Message