Importing database (TransferDatabase) but keeping the same name

[azu_daioh]

Hello,

I split the database into backend and frontend. When I run the reports
in the FrontEnd - it took a long time to process. The backend is
stored in a centralized server (ie. North California) and I'm located
in the Southern California. I don't know if the physical location has
something to do with the speed but accessing the BE from the FE for me
is way too slow. I do want to keep the database split tho' -- it causes
less error.

Anyway, what I'm trying to do is to create another database solely for
reporting purposes. It will not contain any table except for the one I
will be importing from the BE file. I used the macro TransferDatabase
which worked fine at first attempt but when I tested it again, it
created a new importedData table (it added a number in the end)

Is there a way I can import a table from another database and maintain
the same table name? I don't want to end up with 12 tables every year
(I run the report once a month).

Thank you,
Sharon

 

[Guest]

Hi Sharon,

The backend is stored in a centralized server (ie. North California)
and I'm located in the Southern California.

I suggest you read this paper, written by Access MVP Albert Kallal:

Using a wan with ms-access? How fast, how far?
http://www.members.shaw.ca/AlbertKallal/Wan/Wans.html

Is there a way I can import a table from another database and maintain
the same table name?

Yes. First, I suggest converting your macro to VBA code. Use code just prior
to the import to drop (ie. delete) the table of interest. You could also
create a DDL (Data Definition Language) query that deletes the table.

An even better idea might be to simply delete all records from the existing
table, instead of deleting the table, and then run an append query from a
linked table that adds the updated records back in.

Are you willing to give a VBA coded solution a try, or are you stuck on
macros?


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________