validate user (logon) how to

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
 
T

Tom van Stiphout

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
 
Top