Saving the database

[Guest]

Okay, I'm sure I'm not the only one with this issue so maybe someone can help.

Occasionally, I have to transfer my database and my tables to another medium
so that I can work on it elsewhere. Of course, once I do the link between my
tables and my working database needs to be re-established and then I have to
go into each and every query and reset all of the tables and data in each so
that it's looking in the right place to give me the information I need. Is
there a way to avoid having to do this every time?

 

[Douglas J. Steele]

See whether http://www.mvps.org/access/tables/tbl0009.htm at "The Access
Web" helps.

 

[Guest]

Okay, I found the information about the linked table manager, so what I
really need is an answer to a simple question, will this end the need for me
to have to update my queries every time I copy the data from one computer to
another?

 

[John W. Vinson]

Okay, I found the information about the linked table manager, so what I
really need is an answer to a simple question, will this end the need for me
to have to update my queries every time I copy the data from one computer to
another?

Yes, just so the names of the tables don't change. I'm puzzled though
that you've ever needed to change the queries! Do you queries
explicitly use the IN <databasename> syntax, rather than the more
standard linked tables?

John W. Vinson [MVP]

 

[Guest]

Usually, The tables are still there but the joins are missing and a [Exp1:]
is placed in front of each field. I also get a error as soon as I open the
query or form/report based on the query stating that it can't find "field
name" for every single field in the query.

Thanks for the help. Now I know a quick way of correcting the links.

 

[John W. Vinson]

Thanks for the help. Now I know a quick way of correcting the links.
--

Just run the Linked Table Manager - or VBA code which will
automatically relink the backend - before opening your Queries, and
you should be fine.

John W. Vinson [MVP]