Access Database Access Page Problem

rizzir

New member
Local time
Today, 02:45
Joined
Jun 4, 2006
Messages
6
:confused:
Hi All,
I am trying to use simple Microsoft Access Database Access page on my website, just to view customers information.
I created the page using MS Access Wizard, its very standard and simple.
I can view the page perfectly on my local PC.

But i am having problems viewing the page on my website.

My website address is
http://www10.asphost4free.com/rizzir/

I copied the database in db folder of my website
http://www10.asphost4free.com/rizzir/db/online.mdb

Datbase name is
onlinedb.mdb

Database does not need any password

Page which created is standard Customers.htm page
Which works fine locally on my pc.

I opened the Customers.html page in notepad and changed the FOLLOWING CODE

Data Source=http://www10.asphost4free.com/rizzir/db/online.mdb


This is the whole shunk from the Customers.html
<a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=http://www10.asphost4free.com/rizzir/db/online.mdb;Mode=Share Deny None;Extended Properties=&quot;&quot;;Persist Security Info=False;Jet OLEDB:System database=&quot;&quot;;Jet OLEDB:Registry Path=&quot;&quot;;Jet OLEDB:Database Password=&quot;&quot;;Jet OLEDB:Engine Type=0;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password=&quot;&quot;;Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False</a:ConnectionString>

So far i have tried following database paths in html code
\\www10.asphost4free.com\rizzir\online.mdb
http://www10.asphost4free.com/rizzir/online.mdb

I have also tried copying my datbase into
http://www10.asphost4free.com/rizzir/online.mdb

and tried following paths for the database
\\www10.asphost4free.com\rizzir\db\online.mdb
http://www10.asphost4free.com/rizzir/db/online.mddb


I get 2 error messages

"Not a valid filename"

"Dataprovider could not be initialized"

Any idea what is causing this error. how can i fix this.
I had looked around forums but so far i had no luck.

Also reviewed
http://support.microsoft.com/kb/304324/
http://support.microsoft.com/kb/300699
but no joy :(

Any help would be appreciated.

Thanks
rizzir@hotmail.com
 

Users who are viewing this thread

Back
Top Bottom