opening a database within an open database...

[AndrewWolford]

Here's what I'm trying to do... I have a database that needs to be updated to include a table from another database. Right now I'm just importing the table manually by going to ...Get External Data... and then using the import wizzard. Is there a way to open a database from an already open database, then copy a table over to the current database in code? Let me know if this doesn't make sense and I'll try to explain it better... Thanks for any help.

 

[Darrylles]

Hi Andrew,

Yep, you can do this easily.

(You in fact 'link' to the other table, which can then be accessed as if it was a real table in your current db).

Goto TABLES, click NEW, then click the LINK TABLE button (this all depends on your Access version, but similar if not identical). Use the supplied Explorer to find the db which holds the table that you want, open it, select the table you want then click OK.

You now have a 'link table' in your current database.
It's obvious as a 'link' because of the black arrow to its left.
This is not a copy of the table, the link just REFERS to the table in the other DB.

Remember that 'copying' a link table for back-up purposes DOES NOT copy the table - it just copies the link reference.
(If I copied MYLINK1 link to MYLINK2 and made changes to MYLINK1 then on opening MYLINK2 - I would see those changes).

Regards,

Darrylle


"Never argue with an idiot, he'll bring you down to his level - then beat you with experience."

 

[Darrylles]

p.s.

Ignore the hyperlinks in MyLink1 and MyLink2 - it's an automatic feature of Tek-Tips that I wasn't aware of before now.

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience."