SQL 2005 and Microsoft Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

thomasjbs@gmail.com - 28 Sep 2007 14:39 GMT

I have a new database that was created by importing data from a flat
file. It was successfully created and reviewed in the SQL 2005
Database Manager utility. But I cannot seem to access the Tables it
from Microsoft Access. Does Microsoft Access not support SQL
databases via ODBC from SQL 2005?

I can see all the SQL 2005 system databases and tables (which I would
like to Hide from End users) and I finally figured out how to connect
to the SQL database using ODBC, but I don't see any TABLES from the
ODBC database.

Do I need to back rev. the table versions for Microsoft Access?

Reply to this Message

Mark Yudkin - 30 Sep 2007 09:51 GMT

Access XP and above can access SQL 2005 databases without problems. Given
your description, I'd say you had security issues.

>I have a new database that was created by importing data from a flat
> file. It was successfully created and reviewed in the SQL 2005
[quoted text clipped - 8 lines]
>
> Do I need to back rev. the table versions for Microsoft Access?

Reply to this Message