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
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