Can Access 2007 be Run as Admistrator

[Dean Slindee]

Using Vista: have launched an .adp project created at another site on
another computer, using the SQL Server at that site. Now, from home, I want
to change the data source to the local SQL Server database on my PC here at
home. So, I entered the local SQL Server name in the Data Link Properties
dialog box, and pressed the Test Connection button. Getting an error
message: "Test connection failed because of an error in initializing
provider. Login failed for user 'SLINDEED\(My name). If I cannot run as
Administrator or change the server name, Catch 22?

Thanks,
Dean S

 

[55555555]

Using Vista: have launched an .adp project created at another site on
another computer, using the SQL Server at that site. Now, from home, I
want to change the data source to the local SQL Server database on my PC
here at home. So, I entered the local SQL Server name in the Data Link
Properties dialog box, and pressed the Test Connection button. Getting an
error message: "Test connection failed because of an error in initializing
provider. Login failed for user 'SLINDEED\(My name). If I cannot run as
Administrator or change the server name, Catch 22?

Thanks,
Dean S

 

[Paul Shapiro]

If your local SQL Server is using integrated Windows authentication, add
your account to the SQL Server database with sufficient privileges. If your
local SQL Server is using SQL Server accounts, change the Access connection
properties to use a SQL Server login instead of the Windows login.