| | | Tom van Stiphout |  |
|  Posted: Wed Sep 03, 2008 12:11 pm Post subject: Re: validate user (logon) how to |  |
On Wed, 3 Sep 2008 16:41:34 +0700, "SF" <xyz@yahoo.com> wrote:
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
| Quote: | 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
|
|
|
