Problem opening tables created using ADOX

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot open ADO connection to Access 2007 accdb 7
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Is there a ADO.NET equivalent for ADOX 3
Dates don’t work within WHERE clauses 2
SQL Connection Error with MS Access 7
Newly Created tables 5
Create tables : lookup feature 3
ADOX with managed C++ 2

Top