access 2000

[ever]

I have a copy of access 2000. I have format a data base for some customers. I have enter enought field to start entering names in the data base. I would like to be able to continue work on the format of the data base while somebody enters the names. I am new at this. Can someone tell me how I can change just the format of the data base without loosing all the names that was entered.

 

[Duane Hookom]

You should split your application into a front-end mdb consisting of all
your queries, reports, code, forms,... and a back-end mdb that contains only
the tables. You can then continue developing in the front-end off-line while
users enter data into the back-end. Link the back-end tables into the
front-end file.

--
Duane Hookom
MS Access MVP

I have a copy of access 2000. I have format a data base for some

customers. I have enter enought field to start entering names in the data
base. I would like to be able to continue work on the format of the data
base while somebody enters the names. I am new at this. Can someone tell me
how I can change just the format of the data base without loosing all the
names that was entered.

 

[Armen Stein]

You should split your application into a front-end mdb consisting of all
your queries, reports, code, forms,... and a back-end mdb that contains only
the tables. You can then continue developing in the front-end off-line while
users enter data into the back-end. Link the back-end tables into the
front-end file.

Yes. However, if you need to make changes to the table structures in
the back-end database, you'll need exclusive control of it while you
make the changes. Plan and test your changes in another copy, then make
the same changes in the production version while the users are not using
it.

--
Armen Stein
Access 2003 VBA Programmer's Reference
http://www.amazon.com/exec/obidos/ASIN/0764559036/jstreettech-20
J Street Technology, Inc.
Armen _@_ JStreetTech _._ com