File Host | Remortgages | Buy Anything On eBay | Car Loan | Loans
MS Access, Data Access Page Help [Archive] - PCMech Forums

PDA

View Full Version : MS Access, Data Access Page Help


DukeDiablo
10-24-2003, 10:17 PM
Dear Forum-

I'm having a bit of trouble at the moment.

I've got an Access database, I'll call "DB"

I've also got a Data Access Page I'll call "Page.htm"

The problems seems like it would be extremely easy to remedy; however, I've had no luck.

DB and Page.htm work great when they reside on C:, but when I upload them to a webserver I use...www.filebox.vt.edu --> They don't work.

This is how the connection string is when it works...on C:

<a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=\Documents and Settings\Jim and Janice\My Documents\My Received Files\Movie Database Program\MDB_Data\KennedyMovieDatabase.mdb;Mode=Share Deny None;Jet OLEDB:System database=&amp;quot;&amp;quot;;Jet OLEDB:Database Password=&amp;quot;&amp;quot;</a:ConnectionString>

This is how I tried to edit the connection string to use on the webserver:

<a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=\MovieDatabase\KennedyMovieDatabase.mdb;Mode=Share Deny None;Jet OLEDB:System database=&amp;quot;&amp;quot;;Jet OLEDB:Database Password=&amp;quot;&amp;quot;</a:ConnectionString>

This webserver doesn't support ASP pages; however, I didn't think this would fall into that category, being that it's .htm, or is it WHAT the page DOES that matters..not the extension..

I think I've confused myself now so I'll stop rambling.

Thanks for any help.