SQL Log-in when Project Starts

  • Thread starter Thread starter Gene
  • Start date Start date
G

Gene

I would like to disable the SQL Log-in when the project starts and do it
within the application. Everyone that logs in then knows a log-in that gives
then admin rights to SQL Server. Can I log in someway within the
application? Also, is there someway to connect the project through an
Application Role. I'm using Access 2007 but the database is still in 2000.

Any help would be appreciated.
 
Gene said:
I would like to disable the SQL Log-in when the project starts and do it
within the application. Everyone that logs in then knows a log-in that gives
then admin rights to SQL Server. Can I log in someway within the
application? Also, is there someway to connect the project through an
Application Role. I'm using Access 2007 but the database is still in 2000.

Any help would be appreciated.
Click to expand...

I found the answer to the log on question (setting the server log on in
access). As long as no one can see the log on then it really won't matter
that everyone will use the same one.
 
Back
Top