K
Kyle Jedrusiak
We developed an Access project directly against a SQL 2000 database.
We changed the compatibility setting on the database to support v7.0 because
the clients existing database is in v7.0.
Our Access project can log into SQL server and list all of the tables,
queries, views, etc, but I cannot even double-click a table.
I get some kind of collate error 'ADO error: Line 1 Incorrect syntax near
COLLATE.
Kyle!
We changed the compatibility setting on the database to support v7.0 because
the clients existing database is in v7.0.
Our Access project can log into SQL server and list all of the tables,
queries, views, etc, but I cannot even double-click a table.
I get some kind of collate error 'ADO error: Line 1 Incorrect syntax near
COLLATE.
Kyle!