Hello all,
I have an access database that functions as our site Document Control System.
The database holds many forms with buttons that open PDF's on the user's computer depending on which document they want.
The file is held on our shared network.
The error I'm having is when I try to make design changes or update the hyperlinks to the documents It gives me the error: "You do not have exclusive access to the database at this time"
I believe this is because one or multiple people will have the database open at the same time and so design changes are not possible.
As far as I am aware the whole front-end, back-end solution only works with tables and not forms, correct me if I'm wrong.
The solution I've potentially thought of is having some kind of Time-Out on the database so that after say, 5 minutes the program closes itself if the user has not clicked since then.
I am fairly inexperienced with access so I am unsure if this is even possible, or if I am going about this the complete wrong way.
Any help would be greatly appreciated, and let me know if any parts require more clarification. Apologies if this is the wrong post location.
I have an access database that functions as our site Document Control System.
The database holds many forms with buttons that open PDF's on the user's computer depending on which document they want.
The file is held on our shared network.
The error I'm having is when I try to make design changes or update the hyperlinks to the documents It gives me the error: "You do not have exclusive access to the database at this time"
I believe this is because one or multiple people will have the database open at the same time and so design changes are not possible.
As far as I am aware the whole front-end, back-end solution only works with tables and not forms, correct me if I'm wrong.
The solution I've potentially thought of is having some kind of Time-Out on the database so that after say, 5 minutes the program closes itself if the user has not clicked since then.
I am fairly inexperienced with access so I am unsure if this is even possible, or if I am going about this the complete wrong way.
Any help would be greatly appreciated, and let me know if any parts require more clarification. Apologies if this is the wrong post location.