Post reply

SQL Security 2005 - viewable tables from Access

  • September 18, 2006 at 3:10 pm

    #116700

    I have a SQL Server 2005 running on my machine. When I attempt (ODBC & DSN) link an access front end to the SqlServer I only see system tables. No created tables (DBO).

    The reason this is in Admin and not Access is I can connect to SQL Server 2000 and link tables.

    I am using Windows Domain security. domainhere\meAsUser

    Any ideas on why user-created tables (and sprocs) are not viewable?

    thanks

  • September 18, 2006 at 3:51 pm

    #661140

     

    REASON 1

    Unless you specify "Change Default Database to" in ODBC source you have to set a default database for your user domainhere\meAsUser to your database. Then you have to re-link the server from MS ACCESS.

    REASON 2

    domainhere\meAsUser person does not have read access to your tables (?). You may get other error messages in this case.

    Regards,Yelena Varsha

  • September 19, 2006 at 8:44 am

    #661288

    The default database is set to the correct database.

    The id used to go against the SQL2000 was sa. The ID for SQL2005 is domain/user.

    thanks, still looking...

  • September 19, 2006 at 12:43 pm

    #661333

    Informational:

    My desktop has both SQLExpress2005 & SQL2005 installed, new desktop, new job. When connecting I failed to connect-the-dots that it was my machinename/sqlexpress. I connected to SQL (versus express) and imported my target tables.

    Abracadabra - fields viewable from access.

    thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply