Updating network database/file

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

Guest

Hello.
I have several databases that perform updates on excel files or another
databases. The problem is that some colleagues of mine, leave the
files/databases opened when they leave work.

Is there any way to check if the file/database is opened by someone else and
force the closing of the file ? Tipically what i need is something like the
Computer Manager -> Open Files -> Close Open File action does.

Thanks.
 
If the database is not split, split it.
If it is already split, the Front End should be on eash user's computer.
You can also design your app so there is a form that is always open. This
form can have a timer event with logic to see how long it has been since
anything happened. Set it up so the database closes after a length of time
with no action.
Also, using the same presisent form, you can have it periodically check a
table in the back end database for a specific value. If that value is found,
close the database.

When the last user closes his front end, the back end will close.
 
Luis said:
I have several databases that perform updates on excel files or another
databases. The problem is that some colleagues of mine, leave the
files/databases opened when they leave work.
Click to expand...

HOW TO: Detect User Idle Time or Inactivity in Access 2000 (Q210297)
http://support.microsoft.com/?kbid=210297
ACC: How to Detect User Idle Time or Inactivity (Q128814)
http://support.microsoft.com/?kbid=128814

However we found that the code which runs on the timer event must be
disabled for the programmers. Otherwise weird things start happening
when you're editing code.

Also print preview would sometimes not allow the users to run a menu
item to export the report to Excel or others. So you had to right
click on the Previewed report to get some type of internal focus back
on the report so they could then export it. This was also helped by
extending the timer to five minutes.

The downside to extending the timer to five minutes was if a person
stays in the same form and at the same control for considerable parts
of the day, ie someone doing the same inquiries, the routine didn't
realize that they had actually done something. I'll be putting in
some logic sometime to reset this timer whenever they do something in
the program.
Is there any way to check if the file/database is opened by someone else and
force the closing of the file ? Tipically what i need is something like the
Computer Manager -> Open Files -> Close Open File action does.
Click to expand...

Note that you never want to close the connection using this method as
there is possibility of corruption.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Back
Top