separating forms and data

[Mark]

I have an Access database with its tables, forms, macros, and data access
pages in one file. This worked until now, but I need to have my clients
continue working with the data as I concurrently update/develop some of the
forms for an updated look and added functionality. Anyone know how I could
separate the data from the forms and tables.

Also, any help as to how I can accomplish developing new code and update
their project while allowing them to continue to add data into the database
would be appreciated.

Thanks in advance.

 

[tina]

Access 2000 has a Database Splitter, under Tools, Database
Utilites on the menu bar. i don't recall if 97 has
similar, and i'm guessing that 2002 does.

you can also do it manually. i usually create a new blank
database as a base file, and export the tables and
relationships into it from the original db. then i open
the original db, delete the relationships and tables, and
link the tables from the base file back into the original -
which is now my frontend db. in most situations, i put a
copy of the frontend db on each user's hard drive - and
keep the base file on the network.

you can make changes to a copy of the frontend db, then
deploy it to the users whenever you want. recommend you
link the frontend copy to a copy of the base file on your
hard drive while you're working on it, not to the live
base file on the network.

shouldn't be a problem unless your changes to the frontend
require concurrent changes to the base file's tables
and/or relationships.

hth

 

[Tony Williams]

Mark I wanted to do something similar and splitting is the answer. The only
problem comes if you want to change the tables eg adding fields. You cant
import the new table because it would overwrite the data that the users have
input since you last amended them. So if you change anything in the tables
it will mean downtime while you manually edit the existing tables. (Unless
anyone knows differently?????)
Tony Williams

 

[Mark]

tina / tony -

thanks for the replies. I'm going to split and update the front end as I
develop.

thanks,
Mark