ADOX - Copy table to another Access db
Posted on 2001-08-06
I have two Access 97 databases. I need to copy certain tables from one to the other.
I'm using ADOX's catalog to find the table names.
My problem is that the source db is opened through a .mdw file with the user id and password, and when I try to do the copy I'm getting an error saying that that the db is opened by another user (ME!).
I tried using the table name from the catalog and doing a DoCmd.CopyObject and the TransferDatabase method, using the Access 8.0 Object Library, but I get the same error.
Does anyone have any ideas how to copy tables from a secured Access 97 db to an unsecure Access 97 db?
I will give 300 points and an A to anyone who can come up with the answer.