End Access Connections neatly

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If you have a backend access database on a network server with several users
accessing a linked access front end on the same network, is it possible to
neatly disconnect or end sessions for the users so that some maintainance can
be carried out on the application? I guess it would need to happen the next
time a user saves a record that is being updated.

Thanks.
 
I have the same problem with a customer and decided to store all the data in
SQL Server since there you can update and reorganize life.

THe only thing you need to do with your front-end application is instead of
linking it to another access database you should link it to sql server over
an odbc connection.
This linking can be managed dynamically in VBA so you can control the naming.

After relinking basically everything will be working maybe some minor
amendments to be made.


- Raoul
 
Back
Top