designing

[Primepixie]

I want to put all the input data in to one database, and all the forms,
queries and reports in to another. My thinking is that this will help speed
up the database. What would be the best way to do this?

Thank you very much in this matter.
Primepixie

 

[Allen Browne]

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

It will not speed up your database, but there are other benefits.

There is also a wizard to do it for you if you wish:
Tools | Database Utilities | Database Splitter

 

[Primepixie]

Thank you!

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

It will not speed up your database, but there are other benefits.

There is also a wizard to do it for you if you wish:
Tools | Database Utilities | Database Splitter