ADOTables cannt be set to true

[MLNorton]

I have created 15 MSACCESS files. The structure of all 15 is identical having been created by copying from the original ACCESS File. I have installed 15 ADOConnections, 15 ADOTablea and 15 DataSources.

All 15 Connections test successfully. Eleven of the 15 ADOTables can be set to true. Four of the ADOTables cannot be set to true. I get the following error message when I try to set the ADOTables to true;
“Syntax error in FROM Clause”

What is my problem and what is the solution?

 

[DjangMan]

Table names?

 

[BobbaFet]

You'll need to give a bit more information than what you are currently doing, dude. I don't think it is due to the tablenames, that would've made sense if it would've been 5 inaccessable tables.

BobbaFet

if not Programming = 'Severe Migraine' then
                       ShowMessage('Eureka!');

 

[MLNorton]

Each Access File has a name in the format, 1_ABC.dbm, 2_EFG.dbm. etc. The Table name correspond to the Access file name, ABC, DEF, etc. Each Access file contains five fields, LastName, FirstName, EmailAddress, Name combined with emailaddress, ( ie test1 test2 (test1test2@domain1.net) and an integer date in the format YYYYMMDD. I do not think what I am trying to do contribues to the problem. I am reading a master Access file of 3,200 Vietnam veterans and dumping each read record into a specific Access file based on a specific criteria.

 

[DjangMan]

Do you always have problems with the same four tables or, if you open up the tables in a different order, have a problem with the last four?