Access 2003- will not work with the new 2.0 sql

Try changing either A: your odbc connection, or b the link to the tables again in the access db. Should work fine... Mike

or install the free MS SQL 2005 Express Management Studio, way better.

in access use the new project using existing database option and use your SQL login info.

go to the tables, drop the table in the access database (the link) then go file-external data (check where this is first) and then link through the odbc interface if that is how it is setup First, go to control panels, administrative tools, odbc data sources Find the datasource you are using, and verifiy it's setup. (IF YOU ARE DOING ODBC)

Mike

Mike- I was able to connect with ODBC. Are there any limitations using an ODBC conncetion?

Why can I not use query a ADP conncetion?

Crazy thing is that I have another rms DB on another Server and I can query using an ADP conncetion- Whats up with that?

Thanks Brent

Will not work- no query capability -using access 2003, I created a project and connected to the sql server 2005 db. When I wen to create querry, I got this message:

"You have connected to a version of SQL Server later than SQL Server 2000. The version of Visual Studio or Access that you are using was released before the version of SQL Server to which you are connected. For this reason, you might encounter problems. Please check with Microsoft to see if there is a service pack that you should apply to Visual Studio or Office in order to get support for the version of SQL Server to which you are connected. You can continue but any new object types might not be enumerated, and it will not be possible to save any objects or database diagrams that you create using the Visual Database Tools."

Crazy thing is that I have updated all my services packs and updates etc-any idea which service pack I need? thanks Brent