Hello,
Firstly - I'm not sure if this is an Access or Windows question so I apologise if not correct for here.
We use a reasonably large Access 2013 db, spit into front and back ends. Only a small business, typically only 2 users. Front ends are .accdr.
One PC is used as the file server, where the back end resides in a public share folder. A local user on this PC uses our db from a front end installed on that PC as well. This 'server' pc only has Access Runtime installed.
From my PC where I have admin privileges, I can see the shared folder no problem - and our back end data file. Perfect world, all works fine. I have full A2013 installed but still only use .accdr front end (May do some programming but always use the .accdr to go 'live').
But if the local user on the file server PC logs in, opens his front end, then closes, permissions are changed on the back end db file. Note if I am already in the db from my PC this doesn't happen - only if the local fileserver pc opens their front end and no one else is using the db.
Specifically, back end ownership is changed to them (Not sure if it matters), and security permissions are changed to remove me as a user, hence I can't see the shared file any more. Note I am still a member of the file server admins - it's me as \\fileserver\myname that gets deleted. I have same admin credentials on both pc's.
So what happens if ONLY the local fileserver pc front end is opened, is next time I try and log in from my pc I get errors saying no back end available. Look at it from MyComputer and sure enough, no back end file (other files are there). The only fix I have is to log into the file server PC (Directly / remotely), edit properties / sharing to re-add me in permissions on the back end file, then all is fine. Perfect world again - until next time...
We have used the system for many years. Recently we updated our computers going from Windows Server / domain back to just a workgroup (Completely new - pc's, Windows installs etc... so no legacy Server issues).
As part of the upgrade we went from A2007 to A2013 (Not without some fun...) but all seems stable, at least from a vba perspective. In another (Autonomous) office we still run the A2007 version in a similar workgroup format - no issues. So I'm suspicious of something in A2013...
No matter what I try I can't resolve the issue. Not a huge drama while it only effects my PC, but will cause hassles if others need to use the system. Searching Google etc... only returns general security / sharing posts which every one has been tried.
Any advice appreciated. I don't know if it is Access changing permissions / sharing, or something in Windows. Access I am a reasonably comfortable programmer, Windows knowledge not so much.
Thanks in advance
swas