Linked table from VB App

[edojan]

I have an access database that a VB program links into to a specific table.
There are dozens of people linking into this database. Since its separate VB program that links in i cant use auto logo off to do database maintenance. What can i do to create a workaround ? Is there a way in Access to force close links to table ?

Thanks!

by the way i don't have access to vb app, and no network admin access on server file is located ... so it has to be something within access ....

 

[Bilbo_Baggins_Esq]

Assuming you're the db admin, I'd say your management has to face some realities.

Again, assuming you're the db admin, I would push it back up stream to your managerer(s) that the db needs to have periodic maintainence, and the VB developer needs to provide that capability.

Once that reality is accepted, there are numerous options, once you identify your needs as the db admin.

For example, you could write code in VBA in the database to schedule certain events to run automatically, and have that coordinated through a schedule table in the same database.
Then the VB developers could modify their code to look at the schedule table and take those users off-line while your maintainence runs.