Acc 2002 and SQL 2000 setup w/v7.0 Compatibility

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!
 

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

ADO Error 1
Calling Parameterized Query Using SQL Syntax 3
SQL Server and Access 2007 1
Access 2000 and SQL Server 2005? 2
Cascading Combo Boxes w/ SQL in a PRoject 1
Access 2000 ADP and SQL Server 2005 2
Upsizing wizard and SQL Server 2008 Express 4
Access 2002 Project (.adp) / SQL Server 2000 connection problems 0

Top