Database setup question

[Amit]

Hi,

I'm new to Access, so will appreciate any help.

I have a database which still needs some modification and
new forms, but the users need to start entering data right
away in some of the forms.

What I would like to do is to:
a. set up the database for data entry
b. have a separate copy of the database to make changes to
the forms and add new forms (while data is being entered
in the original database)
c. update the original database with the new design and
new forms without corrupting the existing data

Is there a way to accomplish this?

Thanks!

-Amit

 

[Joan Wild]

Just split your database into frontend (all objects except
tables/relationships), and backend (tables/relationships only). Give each
user a copy of the frontend on their workstation, linked to the backend
located on the server. There is a 'database splitter' you can use in the
Tools menu.

When you have finished making changes in your copy of the frontend, you can
distribute the update to the users. Tony Toews has a tool you can use to
automate this. Look for frontend updater at
http://www.granite.ab.ca/accsmstr.htm