update access db question

[bob]

HI

I have an access db w/ tables split into separate db.
when the main db opens it links in the tables from the
other db.

So now I want to create a modification which will alter
the structure of some of the tables in the linked db. I
wanted to put all the code in a fix stuff button that
would be distributed w/ a new front end. My idea was to
copy the data db (w/ all linked tables) to a new db, then
edit the new db by re-arranging tables as I need to and
then re-establishing referential integrity as required,
then I want to replace the current linked table db with
the new one.

Is that possible ?
How do I make a copy of the linked table db from access -
the copyobject method does not appear to apply to mdb
files - only objects in mdb files

If the main db opens and automatically links the tables
from the data db, how do I unlink them in code so I can
create the new tables and then link them instead

I also want the new tables db to have same name as old
when I am done, and rename old to ..._old.mdb

Any help would be greatly appreciated

Thanks
Bob

 

[Jim Carlock]

Use a query to query the link. This will produce information in
the query. Once you can see the information in the query, convert
the query to a make a table query. Make sure you name your
links as follows and your make tables as follows:

linkTable1 <== This is the link
tTable1 <== This is the table

You need to make sure you provide such a naming because with
a link it's all to easy to overwrite the linked data with inappropriate
information.

Once you have the information in a localized table, you can do what
you like with it without having to worry about corrupting the original
data.

--
Jim Carlock
http://www.microcosmotalk.com/
Post replies to the newsgroup.


HI

I have an access db w/ tables split into separate db.
when the main db opens it links in the tables from the
other db.

So now I want to create a modification which will alter
the structure of some of the tables in the linked db. I
wanted to put all the code in a fix stuff button that
would be distributed w/ a new front end. My idea was to
copy the data db (w/ all linked tables) to a new db, then
edit the new db by re-arranging tables as I need to and
then re-establishing referential integrity as required,
then I want to replace the current linked table db with
the new one.

Is that possible ?
How do I make a copy of the linked table db from access -
the copyobject method does not appear to apply to mdb
files - only objects in mdb files

If the main db opens and automatically links the tables
from the data db, how do I unlink them in code so I can
create the new tables and then link them instead

I also want the new tables db to have same name as old
when I am done, and rename old to ..._old.mdb

Any help would be greatly appreciated

Thanks
Bob