modify data structure while users on the system

  • Thread starter Thread starter iccsi
  • Start date Start date
I

iccsi

I have an application which using front end and backend and unbound
form.

It happens that I need add fields in to the table. I got message that
I am not exclusive to use the table, because users are on the system.

I am unable to reach some users to logogg the system, because they are
not in the office.

Are there any workaround for this? I thought that unbound form should
run SQL to get the data which should not lock the table.

Is it the only solution to have all users logoff the sysetm?


Your information is great appreciated,
 
Yes, you cannot modify a database while users are in the system. Try using
the server logs to see who is in the system and send them an email. If that
doesn't work you can kick them out of the system with code like:

http://www.datastrat.com/Code/KickEmOff.txt

If you need a demo of how to use this code, have a look at:

http://www.datastrat.com/Download/KickEm.zip
--
Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com











- Show quoted text -
Click to expand...

Thanks for the information,
does it work if user's computer locked for example if user locks
computer without logoff the system. the application is not activate.
will the code triggle to kick them out?

Thanks again,
 
Thanks for the information,
does it work if user's computer locked for example if user locks
computer without logoff the system. the application is not activate.
will the code triggle to kick them out?

If the Access app is still running, you can set the code to log off the user
within a certain time frame. If the Access app isn't running, they can be
kicked off from the server (or from a remote into the server) using an
administrative console, without any ill effects.
 
Back
Top