Getting the name of a table in a connected access DB

[#1]

Hi all,

I made a ODBC connection to an access Db.

This DB will always have just one Table, but the name of this table could vary. How can I get the actual name of the table?

I know that SQLTable could be used, but this worked for me just when doing a complete reload...but this does not work when doing a partial reload... and I need to do a partial reload :-(.

Any suggestions?

Thanks a lot

[#2 · Accepted solution]

Hi John,

The below works just fine in full/partial reload, i can rename a table, do a partial reload and I'd get the new table list:

OLEDB CONNECT32 TO [Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=C:\Users\Test\Desktop\Employees.accdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=6;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;Jet OLEDB:Support Complex Data=False];

Replace tables:
SQLTABLES;
DISCONNECT;

Do you have a different scenario, script ?

[#3]

Thanks a lot