splitting app & db in 2007

[BBC via AccessMonster.com]

can anyone point me to a step-by-step on how to separate my app/code from the
tables. I've looked at various materials; books, forums, including skimpy
material on the Microsoft access site and couldn't find anthing worthwhile.
Any help & guidance appreciated

 

[Jeff Boyce]

1. Make two copies of the file.

2. Rename one something like "YourApp_FE"; rename the other something like
"YourApp_BE".

3. In "YourApp_BE", remove everything but the tables (all forms, queries,
....)

4. In "YourApp_FE", remove all the tables. Then "link" to the tables in
"YourApp_BE".

5. Celebrate - you're done. (it can get a little more complex, if you're
setting this up as a multi-user application...)

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[BBC via AccessMonster.com]

Thanks, some things are so simple yet hard to find.