Data Access Page Receive Input

  • Thread starter Thread starter Casey
  • Start date Start date
C

Casey

I have a Data Access page (MS Access 2000) that I
placed on a web page that I made with FrontPage 2000. The
data access page shows data, but I cannot seem to change
the data. I would like it to be able to receive input
data for one record, and each time a user opens it up it
would show a new blank record (like a data entry sheet).
Also, I am curious as to whether the MS Access 2000 data
access page will accept data from users on the web that do
not have Access.

I would appreciate a second opinion on this matter if
anyone has a solution.

Thank you
 
Casey,

I am very new to Access but I also created an Access Page
(using Access 2003) that we are viewing with our web
browser in or small office LAN. I was able to set the
edit properties for this page so that records could be
added but not deleted, edited, sorted, filtered, etc. The
following (which is copied from the Access Help Section)
are the procedures that I follwed:

"Specify whether a user can add, edit, or delete a record

In a data access page

Right-click the section bar of a section that belongs to
the group for which you want to set properties, and then
click Group Level Properties.
Do one or more of the following:

To prevent additions, set the AllowAdditions property to
False.
To prevent edits, set the AllowEdits property to False.

To prevent deletions, set the AllowDeletions property to
False.

Note The default setting of the properties in pages
created using Access 2002 is True. In pages created using
Access 2000, the properties are, by default, set to
False. You can open a page created using Access 2000 in
Access 2002 and set the properties to True."

I then went to the Page in Design View and removed the
control buttons that I did not want available on the
page. For example I removed the control button for
the "delete" function by right-clicking on it and then
selecting "cut". So now when other on my LAN view and use
the page they can only add records.

When this page is first viewed it does however, come up
with the first record in the database displayed. I
haven't "yet" figured out how to set it so that it comes
up with a blank entry page. So I can't help you there.

I hope this was helpful.
 
Back
Top