Okay, I have trawled EE and countless other sites, forums, etc and come to a shuddering halt.
I have recently migrated to Delphi 8 (.NET) from Delphi 7. I used to connect to Access dbs using ADO components, which was easy and worked.
Now I am trying to connect to a password protected Access database in a WinForm project from within Delphi 8. I specify the connection string, which when opening an unsecured database works fine.
When I try to open a passworded database, I get the following message from within the debug inspector ...
"Cannot start your application. The workgroup information file is missing or opened exclusively by another user."
There are a few forum threads for this problem, but they either get resolved due to bad syntax in the connection string, or get left without a resolution.
I think my connection string is okay. This is it ...
'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test\afs.mdb;user id=admin;database password=mypassword'
I am tearing my hair out, as all my applications talk to Access databases, and I currently cannot run even the simplest of them.
I have a hunch it could be something to do with the system.mdw file which houses the basic user permissions when starting Access. I have tried creating a new one through the security wizard within Access, but that doesn't seem to have worked.
Any help would be greatly appreciated.