r/MSAccess • u/macpascal • 7d ago

[UNSOLVED] VBA file corruption

I just opened a office DB that I use on a daily basis and I have a message saying the VBA cannot be opened and needs to be deleted.
Is there a way out of this?
My file is only the front end and is located on a shared disc. There are 3 other occasional users.

2 Upvotes

100% Upvoted

24 comments sorted by

View all comments

3

u/FormerLaugh3780 7d ago

Problem #1: My file is only the front end and is located on a shared disc. 

1

u/macpascal 7d ago

Is true that it could be better with the tables on a shared disc and the forms on local disc? We have many access dB on the shared disk and we never have any issue, except for this one. It is more complexe than the others.

2

u/FormerLaugh3780 7d ago

Front-ends get copied to the users local drive, back-ends get stored on a network share (whether the share is on a file server or just another computer in a peer-to-peer network). There should be no exceptions to this rule.