Access 2007 Front end to SQL Database W/ Linked tables - getting prompt for SQL login - Why?
Posted on 2008-10-06
I have an Access 2003 database utilizing Access security (i.e. it utilizes an Access workgroup file .mdw) . The database contains many linked tables to a SQL 2000 database via and ODBC datasource. In the SQL database, every access user is created with the same user name and password as they have in Access. When a user logs into Access they simply enter their Access user name and password and this carries through to the links to SQL. The user is not prompted for a second login to connect to SQL.
I must now run the database under Access 2007. According to Microsofts documentation, I cannot convert the database to 2007 because it utilizes Access security and a workgroup file. The database seems to work fine under Access 2007. However, every time I log into the system, I am now being prompted for a second login for SQL. I must type the same user name and password a second time and then the system runs fine.
Can somebody tell me why I am now getting this second SQL login. Is there a way to eliminate this?