I'm using MS Access as database with my app and I want to prevent users from opening the database mainly to prevent structural modifications.
However, I want my app to be able to use the database without limitations.
I put a password in the database and tried to import it in the Visual Studio's Servers Explorer and invariably got an error message saying that no workgroup information is available.
Actually I don't want to authorize anyone to open/use the database except through the app.
Can anyone explain to me what's the problem and how I can resolve the issue?
Any help shall be greatly appreciated.