Results 1 to 2 of 2
2010-08-03, 07:23 #1
- Join Date
- Jan 2003
- Central Florida, USA
- Thanked 0 Times in 0 Posts
I have an mdb that runs on three workstations. All workstations are running Windows 7 Enterprise and Office 2007. On one of the machines the user is prompted for the SQL Server Login every time a recordset is created in VB. Yet the others are not. The others open the program, click on the control that calls VB code that creates some recordsets, updates some tables and other things and are not prompted.
FWIW - there is an autoexec macro that opens a form (hidden) based on a query where the connection, username and password are included. The form works fine on all but one machine, and prevents the user from being prompted everytime the program needs to access the tables.
Any ideas where to look? Is there a setting some place that I missed?
As always, your ideas and suggestions are greatly appreciated.
2010-08-03, 11:21 #2
- Join Date
- Apr 2001
- Cambridge, UK
- Thanked 3 Times in 3 Posts
Is it using SQL Server Authentification, or Windows Authentification for the Connection?
If it is the latter, then the permissions might be missing from the SQL Server.Andrew