Export database tables (2003)

Topic

New Reply

Hi,

I have the attached code to export tables which are in the same mdb file as the code resides in.

What I would like to achieve however is that I can pass an mdb file name as a parameter and have the code export all tables in THAT file to a new database.

The reason is that I want to create a backup copy of a backend database with just tables.

Is this possible?

Reply | Quote

Replies

You’d have to start a second instance of Access through Automation. See the attached version of the code.

Call it like this:

Dim strRet As String
strRet = ExportTables(“C:TestMydatabase.mdb”, False)

Reply | Quote

Thanks Hans.

Reply | Quote