Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access 97 to SQL 7 login

Status
Not open for further replies.
Kubilus1

Kubilus1

IS-IT--Management
Apr 25, 2001
99
US
I am converting an Access 97 application to a SQL 7 backend and was wondering what is the best way to setup login security. On some clients multiple users will be using a single computer so SQL security must be used instead of NT security.
I've tried having the ODBC datasource ask for userId and password, but it wants to do this between every form.
Is there a secure way to connect the user to SQL only as the application starts?

Thank you for your help,
Matt
 
Status
Not open for further replies.

Similar threads

combo
  • Locked
  • Question
SQL data types in CREATE/ALTER TABLE queries 1
Replies
2
Views
1K
combo
combo
C
  • Question
Query expression negative to a 0
Replies
6
Views
311
dhookom
dhookom
Swi
  • Locked
  • Question
Jet Sql Statement - Select Distinct Multiple Columns 1
Replies
4
Views
889
Swi
Swi
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
4K
lameid
lameid
BugZap13
  • Locked
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
544
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top