T
Tergiver
Scenerio:
I have an Access project which connects to a SQL database. This project
contains forms and reports run against the database. The project file is
physically located on the server (SERVER1) which also runs SQL Server.
I have two computers, computer A and computer B.
Computer A connects to SQL Server using Windows Authentication.
Computer B connects to SQL Server with a user name and password.
I can run the Access project from computer A just fine, but I cannot run it
from computer B. I suspect this is because the project's connection string
was created from computer A using Windows Authentication.
Computer B is running Windows 2000. I don't know why it can't connect to SQL
Server using integrated security, and I don't know how to change it.
Question:
Is it possible to do something with the shortcut computer B uses to launch
the project file that will use a different connection string from the one
stored in it?
I've tried messing around with CurrentProject.Connection from VBA code
(thinking I could have the shortcut launch a macro to change the connection
string), but CurrentProject.Connection seems to be secured from alteration. I
can't change values or even create a new conneciton object and set
CurrentProject.Connection to that new one.
I have an Access project which connects to a SQL database. This project
contains forms and reports run against the database. The project file is
physically located on the server (SERVER1) which also runs SQL Server.
I have two computers, computer A and computer B.
Computer A connects to SQL Server using Windows Authentication.
Computer B connects to SQL Server with a user name and password.
I can run the Access project from computer A just fine, but I cannot run it
from computer B. I suspect this is because the project's connection string
was created from computer A using Windows Authentication.
Computer B is running Windows 2000. I don't know why it can't connect to SQL
Server using integrated security, and I don't know how to change it.
Question:
Is it possible to do something with the shortcut computer B uses to launch
the project file that will use a different connection string from the one
stored in it?
I've tried messing around with CurrentProject.Connection from VBA code
(thinking I could have the shortcut launch a macro to change the connection
string), but CurrentProject.Connection seems to be secured from alteration. I
can't change values or even create a new conneciton object and set
CurrentProject.Connection to that new one.