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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MNPDE - 27 Mar 2006 03:16 GMT

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?

Reply to this Message

Ken Snell (MVP) - 27 Mar 2006 04:20 GMT

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.

Signature

Ken Snell
<MS ACCESS MVP>

> 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?

Reply to this Message

MNPDE - 27 Mar 2006 05:28 GMT

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...

> Is the page's Data Entry property set to Yes, and is the query nonupdatable?
> That can cause the situation you describe.
[quoted text clipped - 8 lines]
> > the
> > title of the page. Does anyone have some ideas?

Reply to this Message

Ed Warren - 27 Mar 2006 12:26 GMT

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------------------

> Thankyou for your response. To answer your questions: the Data Entry
> property
[quoted text clipped - 41 lines]
>> > the
>> > title of the page. Does anyone have some ideas?

Reply to this Message

MNPDE - 27 Mar 2006 21:24 GMT

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

Thankyou all for your input.

> This may apply, it is a snippet from another thread on Data Access Pages:
> -------------snip----------
[quoted text clipped - 57 lines]
> >> > the
> >> > title of the page. Does anyone have some ideas?

Reply to this Message

Ed Warren - 27 Mar 2006 21:57 GMT

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.

> Thankyou for responding. Will Access provide web base data exchange in the
> up
[quoted text clipped - 73 lines]
>> >> > the
>> >> > title of the page. Does anyone have some ideas?

Reply to this Message

Ken Snell (MVP) - 28 Mar 2006 02:54 GMT

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.

Signature

Ken Snell
<MS ACCESS MVP>

>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
[quoted text clipped - 88 lines]
>>> >> > the
>>> >> > title of the page. Does anyone have some ideas?

Reply to this Message

MNPDE - 28 Mar 2006 03:28 GMT

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

> 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
[quoted text clipped - 95 lines]
> >>> >> > the
> >>> >> > title of the page. Does anyone have some ideas?

Reply to this Message