Access Database Access Pages Internet Problem (1 Viewer)

rizzir

New member
Local time
Today, 17:08
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
 

bloody_football

Registered User.
Local time
Tomorrow, 09:08
Joined
Sep 8, 2004
Messages
70
You cannot view Access pages over the Internet and the MS access wizard only creates pages that can be viewed over the LAN.

I made a database for a company I worked for which worked perfectly over the office LAN; then the company expanded interstate so I needed for our interstate salespeople to be able to view the database - bottom line is that they couldn't. Note that it took me 2 months to work this out and I was working on it full time.

If you wish to view the database on your own computer only then you need another copy of the database on your comptuer (or on another computer in the LAN if you have a LAN). But then you have the problem of keeping all the databases in sync if there are several of them.

You need to learn ASP, there is no getting around that.

James
 

rizzir

New member
Local time
Today, 17:08
Joined
Jun 4, 2006
Messages
6
You cannot view Access pages over the Internet and the MS access wizard only creates pages that can be viewed over the LAN.

I made a database for a company I worked for which worked perfectly over the office LAN; then the company expanded interstate so I needed for our interstate salespeople to be able to view the database - bottom line is that they couldn't. Note that it took me 2 months to work this out and I was working on it full time.

If you wish to view the database on your own computer only then you need another copy of the database on your comptuer (or on another computer in the LAN if you have a LAN). But then you have the problem of keeping all the databases in sync if there are several of them.

You need to learn ASP, there is no getting around that.

James

thanks james for your help : )
saved me alot of time
regards riz:rolleyes:
 

Users who are viewing this thread

Top Bottom