Problem opening tables created using ADOX

  • Thread starter Thread starter Jon Jeffery
  • Start date Start date
J

Jon Jeffery

I am in the process of converting an Access.mdb database to an Access.adp
project. The application was originally written using ADO in Access 97, but
currently runs (further developed) using Access 2000 and SQL Server 7
connected via ODBC. I am converting it, therefore to ADO, and connection
without ODBC.

I originally had problems creating temporary tables using ADOX, but have
received assistance on the additional connection required for the Catalog,
and can now create them and delete them OK.

However, once they have been created, I am unable to open them. I have
refreshed Catalog.Tables, and have done Application.RefreshDatabaseWindow,
but can still not see the tables in the database window, and cannot open the
tables using the current database connection.

What am I doing wrong?

Jon Jeffery
 
Further to my earlier posting, I have found the problem stopping me opening
the tables in Access (I am not yet used to ADO, after years with DAO!), but
can still not see them in the database window.

Jon Jeffery
 
Back
Top