Connection string for data access pages

[ericksoda]

I have a data access page that reads a MS Access database. This works fine when the mdb file is on my c: drive, but when I put it on the webserver I get an error message: Microsoft Office Web Components could not open the database "\\website\test\fpdb\database.mdb".

My connection string now is:
<a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=\\website\test\fpdb\database.mdb;Mode=Share Deny None;Extended Properties=&amp;quot;&amp;quot;;Persist Security Info=False;Jet OLEDB:System database=&amp;quot;&amp;quot;;Jet OLEDB:Registry Path=&amp;quot;&amp;quot;;Jet OLEDBatabase Password=&amp;quot;&amp;quot;;Jet OLEDB:Engine Type=0;Jet OLEDBatabase Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password=&amp;quot;&amp;quot;;Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDBon't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False</a:ConnectionString>

Thank you for any help!

David & Faye

 

[JerryKlmns]

Maybe you should post there

Microsoft: Access Project (ADP) forum958

 

[Iashia06]

Hi ericksoda,

Well you need to install the Microsoft Office Web Components. To do this, you need to download the following

http://www.microsoft.com/downloads/...59-0A86-4FB2-A7EE-5F3A499515DD&displaylang=EN

After that, you need to make sure the pages are running on an IIS web server and that the folder has been shared.

 

[fayeinspain]

Thank you Jerry & Iashia,

I posted the thread on Access Projects too.

Iashia, I reinstalled Microsoft Office Web components for office 2000, and Microsoft Data Access components. The database was in the fpdb folder, which I think isn't shared, so I put it out in the main directory and redirected the connection string to the database on the shared folder.

I am using Godaddy's web server, which should be fine as far as IIS is concerned. (Frontpage server extensions are installed, too.)

I'm getting the same error message.

Any other suggestions?

Since it worked when it was pointing to the database on the C drive, but when I moved the database to the web server, it stopped working, I think something could be wrong with the connection string...

Thanks again for your help!
Faye

 

[fneily]

See:
How to deploy data access pages over the Internet

http://support.microsoft.com/?kbid=264080

 

[Iashia06]

Hi ericksoda,

You need to be sure to specify a UNC path, not an absolute path. I had a bit of trouble understanding this, but as long as your folder is shared your connection string should look like this;

\\webserver\sharedfolder$\db.mdb

Be sure to include the $ at the end of the shared folder name. Also, check and make sure that the folder is really shared.

 

[ericksoda]

Thanks for all the advice. It turns out that we never could get the Access pages to work, and had to go back to just Front Page. It works now pretty well.

Thanks!

Faye and David