Database snapshot

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database that contains a number of linked tables.
I need to be able to be able to copy the database to a CD so that I can
access it whilst at an exhibition.

Problem is, when I copy the database is obviously loses the data contained
within the linked tables.

My question is ... is it possible to take a 'snapshot' of the database
containing the data within the linked tables ?

Thanks in advance.
 
AFAIK, no. if you only need to *see* the data while at an exhibition, but
*not* perform any data entry, you could try this:

1. make a copy of "your" database, and do the following steps TO THE COPY.
2. in the database window, click on a linked table to select it (but don't
open it).
3. press Ctrl + c (copy), and Ctrl + v (paste).
4. in the Paste Table As dialog, type an "x" and then the correct name of
the table.
5. under Paste Option, select Structure and Data (Local Table), and click
OK.
6. delete the linked table, and remove the "x" from the name of the local
table.
7. repeat #2 - #6 for each linked table.
8. compact the database.

note: you may have to delete relationships in order to delete the linked
tables. if so, go ahead and do it, then test the database to see if it will
perform the tasks you'll need while at the exhibition. as long as you're
only "looking" at existing data, and not adding/changing/deleting data, it
should work okay.

hth
 
Back
Top