stanl
09-16-2008, 08:24 AM
I make use of several Access tables, created mainly as middleware to quicky import ISAM data into tables via ADO.
When things get confusing, it's nice to know if a table already exists so as to choose between SELECT INTO or INSERT INTO.
In DAO you can query the tabledefs, in ADO the tables collection, or use openschema(), or use ADOX. Of course a simpler way would be
cTable='temp'
....
Select Name from MSysObjects Where Name ='" & cTable & "'"
then check for eof. However, even if you created the MDB, MSysObjects is likely to give a permissions error unless you go into User Permissions and check Read. My question is, can you do this programatically? Stan
When things get confusing, it's nice to know if a table already exists so as to choose between SELECT INTO or INSERT INTO.
In DAO you can query the tabledefs, in ADO the tables collection, or use openschema(), or use ADOX. Of course a simpler way would be
cTable='temp'
....
Select Name from MSysObjects Where Name ='" & cTable & "'"
then check for eof. However, even if you created the MDB, MSysObjects is likely to give a permissions error unless you go into User Permissions and check Read. My question is, can you do this programatically? Stan