Add New Record to Data Access Page

[Guest]

I just came back from a problem call from someone who build their own MS
Access page and published it to the internet. Her problem is that the data
that was entered is showing up and she wants a blank page for users to enter
their registration for a conference. I have never used the MS Access web
features and have limited experience doing on-line stuff. What I think I know
of on-line databases is that there is normally two screens that look
identical - one for editing / viewing data entered and one for adding new
data. The main difference being the connection and how data from the webpage
interacts with data from the database. Am I right?

Do you have any ideas / guidance to help? All the user wants to do is have
somone go to a website, see the data entry form, have it blank / not
accessible to other records in the database, then have the user add a new
record and post it to the database. It seems simple but I have no idea on
how to tell her how to do it.

Any help is appreciated.

Can

 

[aaron.kempf]

I swear it's just a property named 'dataentry' and you should set it
equal to true and not false

or you could do this:

Select * from myTable where 1=0

that should allow you to 'not see previous records' but still enter
new records

if you have a view; and you're doing this; then you can't use 'WITH
CHECKOPTION' is the verbage I believe

-Aaron

 

[Sylvain Lafontaine]

Setting the DataEntry property to true should do the trick. For some info
on this, see the thread "HOw do I prohibit edits/deletes on a DAP" from JR
Hester on 2007-01-25.

 

[Guest]

Thanks.

Setting the DataEntry property to true should do the trick. For some info
on this, see the thread "HOw do I prohibit edits/deletes on a DAP" from JR
Hester on 2007-01-25.

 

[Sylvain Lafontaine]

By the way, the newsgroup for DAP is m.p.a.dataaccess.pages. Reading past
posts is very useful. On Google:

http://groups.google.ca/group/microsoft.public.access.dataaccess.pages/topics

 

[cxx]

Sylvain Lafontaine дµÀ:

Setting the DataEntry property to true should do the trick. For some info
on this, see the thread "HOw do I prohibit edits/deletes on a DAP" from JR
Hester on 2007-01-25.

hello