×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Opening the same file twice on the same computer.

Opening the same file twice on the same computer.

Opening the same file twice on the same computer.

(OP)
Just found a worker opening the Access file up twice on his computer. Then he searches for records in each.
I assume that this is bad. He crashed us today.

Is there anyway to prevent the person from loading up the same file (let's call it Jones.accdb) on his computer?

RE: Opening the same file twice on the same computer.

What about creating a shortcut and teach him to open by double-click it? Access has no built-in feature that prevents from creating new access instance and via File>Open get access to already opened database. API based solution can be applied to block such case

combo

RE: Opening the same file twice on the same computer.

>Access has no built-in feature that prevents from creating new access instance and via File>Open get access to already opened database

Not quite true.

File > Options > Client Settings > Advanced > Default Open Mode

Normally this is set to shared, but you can set it to exclusive.

RE: Opening the same file twice on the same computer.

I am assuming he is opening a Front end... He could just have two copies of the front end and open each. No different than two simultaneous users.

RE: Opening the same file twice on the same computer.

What if you added code in the startup to check for the presence of an lccdb file. While not fool-proof in cases where Access crashes and that file is not removed, at least normally would indicate that the access file is opened and if it is already opened, have the code close the database. I haven't actually tried it to know if that would impact the originally opened file, just an idea though.

RE: Opening the same file twice on the same computer.

(OP)
2/5/2019 For the past 3 days, no crashes since I told our person not to open two copies of the same file.
He was doing a search of a record, looking at the record in Jones.accdb, get's another phone call, did not want to cancel
the screen that he was on, so he clicked on the desktop icon to open the file once more. then crash!

Each night we back up the Jones file to Jones_Backup.accdb

So I made a new desktop icon that gets Jones_Backup.

So far, no crashes.

Glen

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close