Are they the same??

  • Thread starter Thread starter Benn Vosloo
  • Start date Start date
B

Benn Vosloo

In Access 2000,
If I create a new blank database and I import all the
tables from my existing backend database, are they the
same?
 
Benn,

You will have the same data, not necessarily the same database! To have same
database, you also need to:
* Import all objects, not just the tables (i.e. queries, forms, reports,
macros, modules, pages)
* If there is any code at all, either in general modules or in other objects
(forms, reports), make sure you have the same references in the VB window
(Tools > References)
* Make sure all the options are the same: start-up options, database
specific options under Tools > Options.
Maybe there are more that I can't think of right now; if you have created
the original database and don't play around with options, or do the same
changes on the defaults regularly, chances are you won't miss any. If you do
miss something, chances are you'll be able to tell from the different
behaviour.

HTH,
Nikos
 
Back
Top