Not opening two of the same versions of the Front End file? (1 Viewer)

[CJ_London]

was to check whether the FE was running in the same folder as the BE

I go one step further - I specify the location of the front end on a users machine - depends on requirements might be the users docs folder or folder off, perhaps the appdata folder or might be a specific folder on the C: drive. Then the app on open checks it is in the right folder and has the right name. If it isn't it closes with a suitable message.

This prevents users having multiple copies of the FE dotted around their computer.

 

[Marshall Brooks]

Need to back up a bit ...

I never mentioned sharing a front end. What I said was that if I had the FE open already and then clicked a shortcut to the same FE file that I already had open, I got two instances of the same FE running on my computer. The shortcut did not notice that the FE was open and shift focus to that like a shortcut to a Word document would do.

Somewhat annoying to me, but I don't know that myself (or another user, not AND another user) having two versions of the same file open would cause an issue.

I can see User A and User B both having the same FE open on the same network causing an issue. They select another record and the front end jumps for the other user.

Why are you allowing this to happen? Users should NEVER be opening a FE on the server. That you can check also.

This was a hypothetical. User A and User B opening the same FE could be an issue, but is not allowed (any more - it was previously before I learned on here how to prevent it). Now, half our users use Citrix and they open the front end from their own mapped U:\ drive which I'm assuming would be considered on a server, but it is their own copy of the FE. I'm assuming this is not an issue and I don't know of another solution since they can't write to the Citrix desktop. We've been using it for a long time, but that doesn't necessarily mean it is safe.

I go one step further - I specify the location of the front end on a users machine

I do this also now. Has to be on the desktop for local users and the U:\ drive for Citrix users. A bit Draconian, but so far everyone is okay with it.

 

[Thales750]

Who said anything about "supporting the sharing of a front end"?

It wasn't a challenge. It was an actual question.
I've bee using KenHigg's version control for as long as I can remember. It eliminates all those issues, and it doesn't require scripts.

 

[The_Doc_Man]

A bit Draconian, but so far everyone is okay with it.

Sometimes, "Draconian" is the only method they understand.

 

[Marshall Brooks]

I've seen similar to KenHigg's version control before and know other admins that use similar. Works well, but requires two database files.

I use a variation of Bob Larson's file - https://btabdevelopment.com/free-access-tools/ - does need to create a script, but it creates the script itself and deletes the script on startup.

 

[Thales750]

I've seen similar to KenHigg's version control before and know other admins that use similar. Works well, but requires two database files.

I use a variation of Bob Larson's file - https://btabdevelopment.com/free-access-tools/ - does need to create a script, but it creates the script itself and deletes the script on startup.

The dual file system has two advantages.
1. It can be set to disallow the front end from being opened directly.
2. It allows revision to be made without forcing people off the system. It just waits until they close and reopen the front end. We also had a log times that would report if a Frontend hadn't been opened for a period.
Couple that with a SQL Server and you can manage the system completely without User participation.