How to save and restore all data

[pschrader]

Hi !

I'm using MS Access 2003 and Windows XP

On the one hand, there are regular users of our db.
They only change the data in the tables.
They don't change forms, queries, reports or other things.

Once in a while I have to make a change to a form, a query or other
non-table-data things.
But in the meantime, the regular users may keep changing data in the tables.
I would like to get the latest data into my new db version.

Is there a way of copying just the tables to the new db version ?
Is there a way of copying just the table data to the new db version ?

Any helpful suggestions of yours would be appreciated.

Peter

 

[Tony Toews [MVP]]

On the one hand, there are regular users of our db.
They only change the data in the tables.
They don't change forms, queries, reports or other things.

Once in a while I have to make a change to a form, a query or other
non-table-data things.
But in the meantime, the regular users may keep changing data in the tables.
I would like to get the latest data into my new db version.

Is there a way of copying just the tables to the new db version ?
Is there a way of copying just the table data to the new db version ?

You want to split the MDB into a Front End MDB containing the queries,
forms, reports, macros and modules with just the tables and
relationships in the Back End MDB. The FE is copied to each network
users computer. The FE MDB is linked to the tables in the back end
MDB which resides on a server. You make updates to the FE MDB and
distribute them to the users, likely as an MDE.

See the "Splitting your app into a front end and back end Tips" page
at http://www.granite.ab.ca/access/splitapp/ for more info. See the
Auto FE Updater downloads page
http://www.granite.ab.ca/access/autofe.htm to make this relatively
painless.. The utility also supports Terminal Server/Citrix quite
nicely.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/