SQL Log-in when Project Starts

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.
 
G

Gene

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2003 Project Security Setup 2
dbo schema problem and permissions 1
Access 2007 can't connect to SQL Server 1
ADP Project uses 3 connections on SQL server ? 3
Using Access 2007 adp project files with SQL Server 2008 Express 3
SQL Express Login Prompt From Access 2007 ADP 1
Access 2003 Project connecting to SQL 2005 2
Access 2007 ADP (Runtime) and SQL Express 2005 6

Top