Data Access Page Error !!!

[Anand Chettiar]

Hello Everybody ,

My first time posting a question in MS Community
Newsgroup. I am having trouble with DATA ACCESS PAGES in
MS Office Access 2002.

I have a Win XP Pro from which i m developing Access
database and inside that databse there is a Data Acces
Page which i created in order to view it in IE after the
user sends that page as an email attachment.
The problem which i am facing is when i execute the whole
operation of sending the email and opening the attachment
(a data access page) , it gets connected to the database,
binds the data and opens it in the browser but when i do
this same operation in some other Win XP machine , it
opens up a blank page showing absolutely nothing.

All the machines have MDAC 2.5 or later installed , have
met with all the latest critical updates and free of
viruses. It is just a wierd problem and I am having
trouble trying to debug the error .

Reply me asap..

Anand

 

[John Viescas]

The DAP works on your machine because the Connection is set to point
directly to the physical path to your database on your hard drive. If you
want other users on your LAN to be able to use your page, you must put your
database on a network share available to all and set the Connection to use a
location in the form \\sharename\databasename.mdb so that your database
"appears" in the same location to all users. If you're trying to send your
page to users outside your local LAN - well, it can be done, but it's
difficult. You must set the UseRemoteProvider property to True, you must
publish your page on a web server running Internet Information Server with
Remote Data Services, and that web server must be able to connect to your
database.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)

 

[Anand Chettiar]

THanx for the prompt reply

The Database itself is placed on a seperate File Server and inside the Local LAN with UseRemoteProvider = False.
And the path is also set in the format \\servername\sharename\database.md

But its still not opening in other machines

Thanx
AC

 

[John Viescas]

Do the recipients have Office XP installed? (They don't have to have
Access.) A DAP needs the Office Data Source Control to run. Do they get
any error, or just a blank page?

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)

THanx for the prompt reply .

The Database itself is placed on a seperate File Server and inside the

Local LAN with UseRemoteProvider = False.

 

[Anand Chettiar]

Hi,

Some of them have Office XP and some have Office 2000 . And the machines which run Office XP just shows a blank white page with url shwing the path to the Temporary Internet Files folder.

Wheras the ones with Office 2000 shows an error .
"Data Access Component Error" Need to install MS Office Web Component

But rite now i m trying to figure out the machines with XP installed

AC