Backing up tables to external access db's 
Author Message
 Backing up tables to external access db's

I have a table in an access database and when you click a button, it copies
the table into another database. All works fine apart from it not writing
over the table with the same name already there. Iy just adds a number to
the end of the table name and adds it to the tables in the backup db. I want
it to write over the top of the backup table. I tried to delete the table so
that it would do pretty much the same thing but it told me that it was being
used. In the macro I built to copy the table, I first specify to close the
table.

Any ideas on how to get around this one???

Thanks in advance

Murray Chapman



Sun, 15 May 2005 15:06:05 GMT  
 Backing up tables to external access db's
Would you care to post the code you're currently using?

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


Quote:
> I have a table in an access database and when you click a button, it
copies
> the table into another database. All works fine apart from it not
writing
> over the table with the same name already there. Iy just adds a
number to
> the end of the table name and adds it to the tables in the backup
db. I want
> it to write over the top of the backup table. I tried to delete the
table so
> that it would do pretty much the same thing but it told me that it
was being
> used. In the macro I built to copy the table, I first specify to
close the
> table.

> Any ideas on how to get around this one???

> Thanks in advance

> Murray Chapman




Thu, 19 May 2005 12:04:18 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Can't Access External Access Table

2. Making Back-up 's with Access DB

3. MS Access external tables don't work

4. Making back ups

5. Attaching External Access Table to Access Database

6. Can't Delete Tabledef in external DB

7. Copy Access/Oracle table from one DB to another DB.

8. Appending an external file's date to a table

9. External Table Isn't in the Expected Format

10. Access external DB in VBA

11. delete external DB's table from current DB?

12. MS Access DB - Copy Table A from Database A to Table A Database B

 

 
Powered by phpBB® Forum Software