A
aaronshover
Here's a "new" problem. I have this database set up so that it has an
access front-end and an SQL backend. When I open the database on a
computer with the SQL Server client installed it runs fine. When I open
the database (access front-end) on a computer without the SQL client
installed it prompts me to enter some login information to connect to
the server. Is there any way to modify this front-end/backend so that
the login information is automatically entered and it does not prompt
the user to enter it? Just to let you know to make the front-end I used
the link tables wizard to link the tables to the SQL Server.
access front-end and an SQL backend. When I open the database on a
computer with the SQL Server client installed it runs fine. When I open
the database (access front-end) on a computer without the SQL client
installed it prompts me to enter some login information to connect to
the server. Is there any way to modify this front-end/backend so that
the login information is automatically entered and it does not prompt
the user to enter it? Just to let you know to make the front-end I used
the link tables wizard to link the tables to the SQL Server.