aquarian
12-05-2005, 06:10 AM
Hi,
I am a novice web developer and have created a fishing web site on front page for a few of my mates to use. I have created a small access DB as the backend to store my fishing reports. I am using Access Data Pages to create an input form to log each fishing trip and when I view it on my PC using frontpage it works great although when I ftp my files to the web server I can see all the textboxes and dropdowns for the fishing trip entry page but no data. When viewing the HTML source for this page(access data page) there is a connection string with values in it like this:
<a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=c:\my web site\fishdb.mdb
It is not surprising that the web server can not find my C: although I have changed this path to http://www.website.com/fishdb.mdb and just fishdb.mdb and it still doesn't work. When doing a bit of research MS documents when publishing access data pages on a web server the data source must be \webroot\web directory(eg: \wwwroot\fishingwebsite. My web site is created by my ISP and working out what the webroot and web path is, is not easy.
Can any one provide me with a way that I can get access to my database? Or Can you suggest another method in which I could use a database(any) for my on line app? :confused:
All what the database has to do is store about 10 fields describing a fishing trip and produce a tally of who has caught the most fish.
I am a novice web developer and have created a fishing web site on front page for a few of my mates to use. I have created a small access DB as the backend to store my fishing reports. I am using Access Data Pages to create an input form to log each fishing trip and when I view it on my PC using frontpage it works great although when I ftp my files to the web server I can see all the textboxes and dropdowns for the fishing trip entry page but no data. When viewing the HTML source for this page(access data page) there is a connection string with values in it like this:
<a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=c:\my web site\fishdb.mdb
It is not surprising that the web server can not find my C: although I have changed this path to http://www.website.com/fishdb.mdb and just fishdb.mdb and it still doesn't work. When doing a bit of research MS documents when publishing access data pages on a web server the data source must be \webroot\web directory(eg: \wwwroot\fishingwebsite. My web site is created by my ISP and working out what the webroot and web path is, is not easy.
Can any one provide me with a way that I can get access to my database? Or Can you suggest another method in which I could use a database(any) for my on line app? :confused:
All what the database has to do is store about 10 fields describing a fishing trip and produce a tally of who has caught the most fish.