Software

Ask something
Discussion Locked

MS Access data access pages

0 helpful
5 replies

by scott.vrana

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have created a data access page using the wizard in Access 2000. The page works on my local machine fine. I upload the page to the web server and when I try to run it, I get the message "Data provider could not be initialized" then I get "Not a vaild file name". I changed the path of the database to the correct one. How can I get this to work? Any help would be appriciated.

5 replies

by fklein

What other details can you post? What kind of web server? Are you the admin for the web server? etc.

by liliana_ramirez_zambrano

hi, i have made this pages you can edit the path for the db, in your page, for example.\\lramirez\informes\grafico\ you have to put the page in a shared path and then change this path in all the pages and the db must be shared.

by jbeckmeyer

I've been playing around with Data Access Pages for a short while now, and ran into a similar problem. My solution was to specify my database's path as a true network address as opposed to a mapped drive letter. So, instead of "F:\data\database.mdb", I had to specify "\\ServerName\data\database.mdb" in the page's connection string.

HTH,
Jim Beckmeyer

by ma407

I already mentioned this in another THREAD.

I read on MSDN (microsoft) that in order to use the data access pages the web host has to set up certain environmental variables. Spend about 20 minutes and you'll find the link.

I had NO PROBLEMS using ASP to reach the data in the same ACCESS database I had uploaded. However, getting the Data Access Pages to work were nothing less of frustration.

DO two things:

1) Contact your web host. They might give you the correct servername and connection info.

2) USE simple ASP commands to query your access DB. If you can connect with ASP and not with Data Access Pages, do what I do... DROP the Data Access Pages, and program by hand. It is less frustrating to learn ASP, PHP or Visual Basic. Trust me!!
I wasted a month with DAP!

by jacksontee

Have you addressed the issue? I facing the same problems also.. Is there any help?

Thanks
Jackson

This discussion is closed to new replies.