validate user (logon) how to

  • Thread starter Thread starter SF
  • Start date Start date
S

SF

Hi,

How can I validate user (logon) before allowing user to get into Access 2007
(backend tables are on SQL Server with trust authentic)?

SF
 
AFAIK there is no "trust authentication" for SQL Server, only Windows
authentication and SQL Server authentication. I trust you meant the
former since there are few reasons to do the latter.

No logon is needed. At startup time you can run a stored procedure to
get some initial information for your app. If the call fails, your
error handler will get control and do the right thing. Perhaps a nice
message and boot the user out with the DoCmd.Quit instruction.

-Tom.
Microsoft Access MVP
 

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

Moving to 2007 1
Disable some feature based on login Info 2
Access Issue, Macro Single Step, Error 3270 0
Call Link Table Manager windows from VBA 5
Integrate MS Access 2007 and SharePoint 2007 Server, Authentication and Authorization problems 5
Write conflict error with ODBC link table 2
ADP Custom Logon Form? 2
Additional SQL Link Fails for Trusted Logon 6

Back
Top