Wednesday, March 28, 2012

How do I locate a Database on SQL Express from Access 2003.

Access 2003 Data exported to SQL Express , great.

How do I then link the tables to the new database, I only seem to be able to link to system tables etc ?

Any ideas ?

Hi,

I assume that you are trying to link external table(s) and going through "ODBC Databases"? Then you probably have an ODBC DSN defined?

I've done that and my user table is neatly sean in the list together with the system views, etc. What you are probably experiencing is a misalignment of permissions. The following chain should be unbroken in order for you to see the user tables:

(a) Client Application security context (in this case - MSAccess)

(b) ODBC DSN connection settings - are you using SQL Authentication?

(c) SQL Server account (SQL or NT authentication)

(d) Database user associated with the account

(e) Appropriate schema/object permissions

Check each of these and see if everything is in order. You could also experiment with the SQL Management Studio or SQL Query Analyzer with the credentials used in MSAccess and see if the table(s) would be visible.

HTH,

Jivko Dobrev - MSFT

--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Many thanks, sorted, hadn't selected database from options for users.

Thanks again Racing Snake

No comments:

Post a Comment