Log off with out restart of acccess

S

Shadow0058

is there a way to log off a user from an ADP so that another user can log on,
without having to close down access?
 
N

Norman Yuan

I haven't tried it myself, but you can give it a shot:

Use CurrentProject.CloseConnection() to and set CurrentProject.Connection to
"Nothing" when a user "log off" your ADP app without quit from it. When next
"log on", use Current.OpenConnection() to reconnect APD app to SQL
Server/MSDE. Of course you provide a "log on/off" form in the ADP app, don't
you?
 

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

Changing login email address for office 365 admin (O365 Busines) 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Can I restore the database without the log file? 0
Word 2016 opening sooo slow 0
Security Question 3
System slows down when more users log on 6
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Access 2003 ADP/SQL Server 2005 - parameterised row sources do not work 5

Top