Why can I not see any fields on my Data Access Page?

M

MNPDE

I've successfully created a simple table and made simple data access pages
that do all I need at this stage on my work PC. When I repeat the exercise on
our company webserver, I don't see any of the pages fields. All I see is the
title of the page. Does anyone have some ideas?
 
K

Ken Snell \(MVP\)

Is the page's Data Entry property set to Yes, and is the query nonupdatable?
That can cause the situation you describe.

If that's not it, then tell us much more detail about your page and database
setups.
 
M

MNPDE

Thankyou for your response. To answer your questions: the Data Entry property
is set to 'yes' and I've linked the page to the one and only table and not a
query.

To keep things simple I will confine my questions to the simplest of my Data
Access Pages. It is a straight forward data entry page. I make it with
'create data access page by using the wizard'. I choose the table and then
fields including the primary key (and only key). I also have the navigation
tool bar for the table on the page.

The only property I change is the Data Entry property to true. I save the
page in no particular, but the same directory as the '.mdb' file on our web
server. When I save the page and reopen for edit I notice the navigation bar
has not drawn itself properly.

As I say I can do all of this on my own machine without the troubles above
and I am satisfied with its function. Our web server is Win98SE based as is
my machine and I am using Access 2000.

Thankyou once again for responding...
 
E

Ed Warren

This may apply, it is a snippet from another thread on Data Access Pages:
-------------snip----------
Hi Ed
Not exactly true. Data access pages (DAP's) created with Access 2000 require
all users to have a license for Office 2000. Each user needed to have a copy
of the Office Web Components DLL library (OWC9.dll), which could not be
freely distributed. I believe this license requirement was removed with
Office 2002. However, all users must still have a copy of Internet Explorer
installed, as any other browser simply will not work.

Furthermore, DAP's are being deprecated in the next version of Access due
out. It's about time that that happened.

Tom
--------------------end snip------------------
 
M

MNPDE

Thankyou for responding. Will Access provide web base data exchange in the up
comming version?

Thankyou all for your input.
 
E

Ed Warren

I don't know, Tom was correcting me. I had thought that you needed Access
to read any DAP, but he says you can read them without Access if they were
built with MS Access 2002 or 2003. I can't confirm or deny that, someone
with 'knowledge' will have to help there.

Tom does go on to say the DAP's may not be in the 'newer' versions of MS
Access.

Ed Warren.
 
K

Ken Snell \(MVP\)

Users with ACCESS 2002 can use DAPs via Internet Explorer (and no need for
ACCESS itself) so long as the Office XP Web Components library is installed
on the user's PC.

The server that holds the database itself does need ACCESS for the database
to work correctly for the DAPs.
 
M

MNPDE

Thankyou Gentlemen I'm satisfied. I will upgrade to XP and the latest Access.
Thankyou again.
 
Top