Linking database to data access pages

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Ok, here's the deal. I am using MS Access 2002...I have my database all
setup, I created data access pages for all the forms I have that I want my
users to interact with, I have web space on the local intranet here at work
which I've uploaded everything to and the pages show up fine on the web and
everything.

However, when I go to the website and enter information in one of my web
pages and save it, it saves the information to the location I was working on
the database with on my hard drive before uploading it to web space. So,
everything I enter in the website works fine and saves fine, but saves to the
database on my hard drive rather than the database that is there with the
pages on the web server.

How can I tell my data access pages to save information to the database on
the web server and not my hard drive?
 
Open the Data Access Page in design mode. Right-click on the top control bar
of the data access page. From the popup menu select "Page Connection...".
Then click on the "Connection" tab. Enter the location of database in the box
titled "1. Select or enter the database name".
 
Thanks for the response. However, after right clicking on the control bar
while in design view and choosing "Page Connection.." nothing pops up at all.
Any idea why this would happen?
 
No idea. Let's approach from a different angle. Open the Data Access Page in
design view. From the Access Menu Bar at the top, click on "View", then
select "Properties". Then click on the "Data" tab. Click in the
"ConnectionString" box to make the "..." appear to the right of the box.
Click on the "...". The "Data Link Properties" will appear. Then click on
"Connection" tab. Fill in the proper location for the database.

If the above does not work, instead of clicking on the "...", right-click on
the "connectionString" box. Select "Zoom". Find the "Data Source" parameter
and replace the old location with the new location.
 
Back
Top