segregate tables in diff. files

[kitjamchinkee]

Is it true that the database file(using access as the back-end) won’t expand easily if you will separate the tables into different .mdb files? Why? I need to know. Thank you very much!!

 

[Robertd]

Seperating the application from the data tables shouldn't be difficult!<br><br>create a new blank table for the frontend file<br><br>import all the queries, forms, reports and modules, macros if you must,<br>no tables! (except work and house keeping tables as required)<br><br>then right click in the db window and link the data tables from the origional table<br><br>that way you keep the relationship diagram neater.<br><br>if you want you can also compact the data tables mdb file to a new file and also have the relationship diagram intact<br><br>i have only had experence with mdb files upto 30Mb (no problems)<br>