Why Split?

[Guest]

Why should I split my database, and where have my forms and macros and
queries gone?????? (have already split just out of curiosity)

 

[Allen Browne]

See:
Split your MDB file into data and application
at:
http://allenbrowne.com/ser-01.html

 

[Guest]

Ok thanks. But I should do this when I'm completely finished shouldn't I?

 

[Allen Browne]

Yes. Towards the end of development is normal.

Once the structure is stable, and most pieces are in place, but before your
major testing.

 

[Arvin Meyer [MVP]]

Ok thanks. But I should do this when I'm completely finished shouldn't I?

I prefer to split early or at the beginning of development because it makes
backups easier, allows me to email smaller files, allows creating separate
table sets with test data, and is generally more flexible. Typically, I
design my table structure first and rarely change it very much during
development, so splitting early is rarely, if ever, a problem.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Albert D.Kallal]

I give a detailed explain as to why you should spilt here"

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

In the above, I also explain at what point in time you will want to
split....