Hi,
I'm in the process of converting a complex database written in Access 2007 to a web enabled version. I would like to continue using the Access 2007 database as a back-end repository.
The accdb file is encrypted with a password and I have no problems accessing it directly in Access 2007.
I use Dreamweaver 8 to edit the pages and DW8 again has no problems displaying the tables/queries etc.
However, when I try to open the files using the DW8 generated web pages (IIS localhost), I get an 'invalid password' error.
I use a connection string: MM_dataCon_STRING = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\inetpub\wwwroot\site\database.accdb; password = xxxxxx;"
If I use: MM_dataCon_STRING = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\inetpub\wwwroot\site\database.accdb; password = xxxxxx; userId=admin;"
then I get a message about a missing Workgroup Information File - I understood that Access 2007 doesn't use that.
If I remove the encryption and reference to the password/user then everything works fine.
Does anyone have any ideas how to use an encrypted Access 2007 file via asp pages? Is it even possible?
Help!
Bernard D
I'm in the process of converting a complex database written in Access 2007 to a web enabled version. I would like to continue using the Access 2007 database as a back-end repository.
The accdb file is encrypted with a password and I have no problems accessing it directly in Access 2007.
I use Dreamweaver 8 to edit the pages and DW8 again has no problems displaying the tables/queries etc.
However, when I try to open the files using the DW8 generated web pages (IIS localhost), I get an 'invalid password' error.
I use a connection string: MM_dataCon_STRING = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\inetpub\wwwroot\site\database.accdb; password = xxxxxx;"
If I use: MM_dataCon_STRING = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\inetpub\wwwroot\site\database.accdb; password = xxxxxx; userId=admin;"
then I get a message about a missing Workgroup Information File - I understood that Access 2007 doesn't use that.
If I remove the encryption and reference to the password/user then everything works fine.
Does anyone have any ideas how to use an encrypted Access 2007 file via asp pages? Is it even possible?
Help!
Bernard D