Data Access Pages in Access 2000

S

stevens

I have tried making a data access page from a table in Access, and it looks
fine in design view, but when I switch to form view, the data and controls
disappear, leaving me with just the text I put on the page. Is this a flaw
or a bug in Access 2000? Has anyone else come across this problem? How do
you solve it? Thanks
Steve
 
K

Ken Snell [MVP]

What is the Recordset of the section in which the "elements" (they are
called elements in a DAP, not controls) are located? Is it the table or a
query? Did you specify the UniqueTable property for that section? Is the
Data Entry property set to Yes (should be No)? How are you viewing the
DAP -- where is the database located from which the DAP is supposed to get
its data?

How did you create the DAP -- via wizard? via Save As from the form?
manually?
 
K

Ken Snell [MVP]

When in design view, right click on any part of the page. Select Page
Properties. Go to Data tab. Data Entry property is set on that tab. Should
be No unless you plan to use the page just for entering new data.

Then, right click again and select Section Properties. Select Data tab. The
Unique Table property is set there. In order to be able to edit the data,
you must select the table that contains the data that will be edited. If the
section's recordset is just a table, you still need to have the table's name
in the Unique Table property.

Make sure that each element (Element Properties, Format tab) has its
Visibility set to Inherit or Visible. If on Inherit and the element isn't
visible, then change it to Visible and see if that helps.

Is there any data in the table that is the source of the page?
--

Ken Snell
<MS ACCESS MVP>
 
S

stevens

When I right click on the page in design view, I do not have a page
properties selection. The only thing I have is "properties". When I open
that up, under the data tab, the only selection is "DataFormatAs". There is
nothing else. I set all the elements properties to visible and now they
show up in page view, but have no data. Yes, there is data in the table. I
also do not have a UniqueTable property anywhere that I can find. The only
thing I find is when I click on the table button on the toolbar, it opens a
way to add the table to the page. Even then, when I do that, nothing
happens. I also noticed that when I opened the table box first, the
database was X'd out, and I had to add it and test the connection. It says
the connection succeeded, but no data shows up in the elements. Is
something not installed correctly?
Steve
 
K

Ken Snell [MVP]

Hmmm ... I may be of little use to here after all.

It appears that ACCESS 2000 DAPs are structured differently than ACCESS 2002
DAPs, and I have only ACCESS 2002 on my PC.

I can only suggest that you try building the page from scratch again. When
you want to add the table's fields to the page, don't drag the table name
from the field list; instead, highlight all the fields under that table and
drag them as a group.

Other than this, I don't know what else to suggest, as I know that there
were significant changes made from 2000 to 2002 with DAPs (from what I've
read by others).

--

Ken Snell
<MS ACCESS MVP>
 
Top