Is it possible to sep data from desgin?

[LPA]

I am going to start creating an access project and ship updates to my
customer via email.

Is it possible to seperate the data from the forms/reports? Or do I have to
come up with an import/export utility for the customer to use.

 

[Cheryl Fischer]

The answer to your question is a strong and resounding YES. Create two
databases: The Front-End will contain all Objects but tables; the Back-End
will contain tables only. Use the FE of the database, clicking from the
menu File|Get External Data|Link to link to the tables in the BE of the
database.

Here is a link to Access MVP Tony Toews' website that will provide further
info on Access Best Practices, among these is a link with more info on
Splitting Apps.

http://www.granite.ab.ca/access/bestpractices.htm