Appication.Quit doesn't work on Network users

[unknown2u]

My database is used by a few users on a shared drive in "read-only" mode so they can't change any data.

I set a scheduled task to copy an updated version of the database (which I edit) every morning.

The problem is that when the users forget to close the database file I can't overwrite it.
For this purpose I wrote a small code that quits the application at 00:00 using Application.Quit.

The code WORKS when I test it on my computer, but every morning when I try to open the file I see that it is opened by another user since I also open it as "read-only" - meaning the code didn't work...

I need your help in either getting the code to work properly OR get a better solution to be able to overwrite the file even though it's opened by other users.

Using Access 2010.

THANKS!

 

[unknown2u]

Anyone can help please?

 

[BlueIshDan]

Application.Quit acQuitSaveNone

 

[BlueIshDan]

are you actually changing something in the design of a form or something?
Why do you wish to overwrite the file?

 

[BlueIshDan]

Also a better structure is to store the tables in an access database title "[name of database]_Backend" on the network and link those tables to a copied down front end access database on each user.

 

[unknown2u]

The structure of the database works well according to the basic guidelines of how a database should be built with relationships and all that...

I'm past that part.

What I'm changing in the database is the data itself... records always change since it's dynamic data.
I change it almost every day add/remove records

 

[BlueIshDan]

I'm not questioning your datatable structure. Just giving you a couple solutions.

 

[unknown2u]

Yeah I understand.
What I want to overwrite is the data itself - records mostly..

 

[BlueIshDan]

Access should handle that.

 

[BlueIshDan]

try Application.Quit acQuitSaveNone

that counts only for the design of tables & forms. The data should be saved fine.

 

[unknown2u]

Thanks, I'll give it a shot.

But would that quit the program on other users' computers as well?

What could be the reason for it not working on another computer? It's just a quit command isn't it?