Unanswered: You do not have access to the database at this time
I have a front - end application that performs fine - compiles etc. Problem is that once I go into design view of any form and then save my changes (the changes are in fact saved) the next time I try to make changes I get the file is in use by another user, etc. and i cannot save my changes. if i exit and come back in - I can make a change or a series of changes - but once I save those changes i have to go out and back in to make more changes.
The Laccdb file is being deleted correctly so there are no issues with the hanging laccdb file. I can make these changes to the objects (any object) design or in the VBA project - hundreds of edits/modifications/changes if I desire and click save and everything saves. But to try another change - the messages start popping up - and i have to exit and come back in to make changes.
In your opinions should i just create another container and import my objects - I have not tried the decompile swith yet - so perhaps i will do that after this post.