data access pages not working on web.

[Sandy]

I hope someone can help me...I create a data base, save it to local web
folder, upload to website, then create the table, save as data access page
and upload to web. When you try to go in it is looking for the database on
my local machine, not on the website. I am new to access, but it doesnt seem
like rocket science!

please help, I am desperate.

SAndy

 

[Ken Snell \(MVP\)]

When you create a DAP (data access page), its Connection property is
established with the path to the database file in which you're working at
the time of creation. If the path to that file is not the same as the path
to the database when it's on the web server, you cannot make things work on
the web.

For already established DAP, you'll need to open the page in Edit view, open
the Properties window, and modify the Connection property to be the actual
path to the database file when you're running on the web server.

 

[Sandy]

HI Ken,

Okay, I was wrong I can't figure this out. I think I've been working on it
too long, but hope you don't mind answering another question. If I was to
create this from scratch so that it works, how should I do that? Is it
improper of me to ask for your email address? It would probably be easier
(if you don't mind) if I just bug you straight away. I was so disgusted when
I tested my work on my laptop and realized it wasn't working right. Thought
I had it aced, and I need to have it done by tomorrow at 11. Nothing like
working under pressure.

Sandy

 

[Ken Snell \(MVP\)]

When I did some work with DAPs, I created a directory on my PC that had the
same path that would exist on the web server. If I recall correctly, it was
C:\inetpub\MyFolerNameHere\

I put the .mdb file in thie above folder. I created all the DAPs at that
time.

On the web server, I duplicated this path:
C:\inetpub\

I then copied MyFolderNameHere, with its files and subfolders, to the web
server path.

One other item. A DAP has a Page Property called UseRemoteProvider. When you
work with the .mdb file on your PC, that property usually is set to No so
that you can test the DAPs. However, before you copy the .mdb file and all
the external .htm files (the DAPs) and the associated subfolders, open each
DAP in Edit mode and change that prroperty to Yes for each DAP. Then copy to
the web server.