moving table from one datbase to another (1 Viewer)

bigmac · Jan 29, 2019

hi all can you help please, I have two databases both with a table called [new load],can I move one table to the other database and overwrite the other table?

if yes how? and what pitfalls have I got to watch out for ?

theDBguy · Jan 29, 2019

Hi. Care to elaborate on why you need to do something like this? It may be you don't have anything to worry about or we might say don't do it, depending on the actual situation.

NauticalGent · Jan 29, 2019

Yes you can. You would do it by using the External —> Import —> Access group menu. Depending in which version of Access you have the actual menu sequence may differ slightly, but it is pretty straight-forward.

As far as pitfalls go, if the table structure is identical then there should be no issues. If they are different, any objects that are dependent on them, such as queries, forms and reports, may have to be redone.

isladogs · Jan 29, 2019

If there is a good reason (do explain why) you can do it as NG suggests or you can open both databases side by side and drag the table to the new dB.
However you do it, it won't overwrite the original with the same name. Instead it will create a new table with a '1' at the end.
You can avoid that by deleting the original first or just rename the new table afterwards

Cronk · Jan 30, 2019

And to answer the other question in the OP

and what pitfalls have I got to watch out for ?

Are there any records which are related to those in the table being replaced? You might have cascaded deletes in the other tables or orphaned records.

bigmac · Jan 30, 2019

theDBguy said:
Hi. Care to elaborate on why you need to do something like this? It may be you don't have anything to worry about or we might say don't do it, depending on the actual situation.

hi all sorry for delay, the reason for doing this is that I have found that a user has taken a copy onto his desktop and updated some records in the table , I need to copy this table into the original database to get it back on track

theDBguy · Jan 30, 2019

bigmac said:
hi all sorry for delay, the reason for doing this is that I have found that a user has taken a copy onto his desktop and updated some records in the table , I need to copy this table into the original database to get it back on track

In that case, you could copy the table (or just link to it) using a different name, so you can use queries against it to decide which records to catch up. I wouldn't "overwrite" the original table.

moving table from one datbase to another (1 Viewer)

bigmac

Registered User.

theDBguy

I’m here to help

NauticalGent

Ignore List Poster Boy

isladogs

MVP / VIP

Cronk

Registered User.

bigmac

Registered User.

theDBguy

I’m here to help

Similar threads

Users who are viewing this thread