data access page synchronize, update or what?

[Ronda O'Connor]

I have created data access pages for 3 tables in my database. I successfully
inputted an additional record, which shows up on the data access page.(It's
the 18th. record) but in my database I only have 17. I have searched for a
way to update the database with whatever is input into the DAP; however, the
only thing mentioned is synchronize under the tools list in Internet
Explorer. I have Internet Explorer 7 but there is no synchronize choice
anywhere.

 

[Sylvain Lafontaine]

The synchronisation should be done automatically when the focus change of
record. Also, make sure that you have defined a primary key for your tables
and that the request that you are using to retrieve the record is an
updatable request (ie., it doesn't contain a Group By, etc.).

There is also a parameter somewhere to make your page read-only; however, if
this is the case then you shouldn't be able to add a new record in the first
place, if I remember correctly.

Finally, using and/or learning DAPs is probably a lost of time; as they are
now officially deprecated by MS and that they are very hard to develop with
if you want anything but the simplest forms. This is from my personal
experience with DAPs a few years ago. Don't make the same mistake as me.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)

 

[David W. Fenton]

=?Utf-8?B?Um9uZGEgTydDb25ub3I=?= <Ronda
O'(e-mail address removed)> wrote in

I have created data access pages for 3 tables in my database. I
successfully inputted an additional record, which shows up on the
data access page.(It's the 18th. record) but in my database I only
have 17. I have searched for a way to update the database with
whatever is input into the DAP; however, the only thing mentioned
is synchronize under the tools list in Internet Explorer. I have
Internet Explorer 7 but there is no synchronize choice anywhere.

DAPS have been deprecated by MS and were never any good to begin
with. I'd recommend abandoning them and going with some other
technology.