updating a database

[Guest]

Hi,
I am supporting a database. I have been working in a copy of the active
database, adding reports, queries, updating the switchboard, etc.
Is is possible to just transfer the main table that has all the records to
the backup I'm working on and rename it instead of transferring all the
updates to the active database?
Any major forseeable problems?
Thanks,

 

[Guest]

Hi Steve

There are a few problems with doing this. ie. You will need to "redo" the
relationships, etc. But ...... I do it all th time when developing a new DB
or making major chages (if you work on a copy it is good to see how it works
in the real world).

So as long as you are working on a copy of the DB give it a go and see if
you have too many prolems. - - - Don't forget to name the imported table the
same as the old one.

Good luck

 

[Larry Linson]

Hi,
I am supporting a database. I have been working in a copy of the active
database, adding reports, queries, updating the switchboard, etc.
Is is possible to just transfer the main table that has all the records to
the backup I'm working on and rename it instead of transferring all the
updates to the active database?
Any major forseeable problems?

I'm assuming you are new to these newsgroups, or you'd have seen this advice
time after time.

You should split your database. Create a "front-end" (user interface)
containing the queries, forms, reports, macros, and modules and give a copy
to each user. Create a "back-end" containing the tables with data, and
relationships. Use the Get External Data to link the front-ends to the
tables in the back-end; then, if the path to the back-end changes, use the
Linked Table Manager (Tools menu, under Database Utilities).

Recent versions of Access include a Database Splitter in the Tools menu,
but, in fact, you don't need it -- make two copies of your database. Delete
the tables and relationships from one, which will become the "front-end";
delete the queries, forms, reports, macros, and modules from the other,
which will become the "back-end". Open the front end in design view, and
File | Get External Data | Link to link the tables.

Henceforth, you won't face the problem you describe.

For more information, visit MVP Tony Toews' site
http://www.granite.ab.ca/accsmstr.htm.

Larry Linson
Microsoft Access MVP

 

[Guest]

Thanks, it worked great. Just had to redo all the table relationships.