Shared Front End

[Nymandus]

First, let me say I am relatively new to Access 6 months self-taught and 2 active databases and I am a quality analyst not a computer person.

Second, I just found the thread saying shared front ends are not a good idea. but for now I have users following a link to 2 separate FE files (one for each location, as we are in different cities on opposite sides of the country)

Third, I had my first instance of an error and this is where my questions begin...

My database is tracking call evaluations for a call center. I am using the Primary key to number the call evaluations with it set to incremental and indexed (no duplicates)

The database worked well for a month and a half. Friday we had a problem where one user’s evaluations overwrote everyone else's that were processed the same day. (After reading the shared FE thread is see this as the possible reason)

1) Do you know is the shared FE the reason?

2) I wanted the shared FE for ease of updating the FE as I am not the computer tech and don’t have access to each person's computer. My next idea...instead of emailing updates on a regular basis to each person, would it work for me to have a separate FE folder for each person (15 max) on the servers (one for each location) and have separate links sent to each person?
My thought would be their link will never change and I can update on the fly when I see that person is not in the FE.

I ran the compact and repair on both FE files as well as the BE and it seems to be working again but....fool me once....

Any help with both questions would be greatly appreciated.

 

[Nymandus]

Not being a programmer I freely admit it is possible I made an error... is there any way I can find that error and fix it?
what seems to be, right now, is that one user is at the root of the problems but she should not have any greater access than the rest of us, including me, (4 of my evaluations were over-written by her). She is using the same front end as the rest of us. The form we are using does not have alot of options to make mistakes with as a user.

what is the maximum size a table can get to?
is there a maximum BE or FE file size?

 

[Nymandus]

I will do some testing... I hope... I do not have seperate security access set up for each person. we all use the same Password to access the FE. shoudl that make a difference?

So my overwritting issue should not have anything to do with the first person or the last person to open the FE file?

thank you for the link I will go there now.

 

[Nymandus]

ok so size does not appear to be an issue as the total size of the BE file right now is 1.59 MB....

 

[Nymandus]

We just had the issue again... I think I may have had a problem in my save button it had extra syntax in there... but that beign said I also looked at the Data field on the form
filter on load is set at no---should this be set to yes (is there anything else that would need to change with that?)
record locks is set to no locks-- should this be changed to "edited records" or "all records" ?

 

[way2bord]

It's also possible the front end has tables on it. Shared temp tables due to shared FE. Bad idea.

I recommend dividing the database into 3.

Your data backend. (located on network) - store data here.
Your development frontend. (doesn't matter where it's located) - make all changes here
Your local copy frontend * no. of users. (This is located on every PC) - local users copy a version of the development frontend to their local harddrive.

 

[Nymandus]

If I do decide to push a copy out to each person's desktop how do I ensure they do not have a "personal copy" of the database? In the past we have had issues with Access databases being copied to the desktop and from that point on it was a stand alone copy with their own set of evaluation numbers?


anyone know about the form portion of the questions and setting the data a filtered and record locking in the data properties? will that help or cause problems?

 

[way2bord]

If I do decide to push a copy out to each person's desktop how do I ensure they do not have a "personal copy" of the database? In the past we have had issues with Access databases being copied to the desktop and from that point on it was a stand alone copy with their own set of evaluation numbers?


anyone know about the form portion of the questions and setting the data a filtered and record locking in the data properties? will that help or cause problems?

As mentioned - all front end databases (forms + queries + linked tables only - no tables) should point to a single back end database (tables only) housing all data.


A poor man's fix for version control:

Change the name of the Backend every time you want to force users to download a new frontend.

Because all data in a frontend is linked tables (pulling data from backend), changing the name of your backend will break all links and will crash the front-end if the new version of the database is not downloaded.