General discussion


Web Interface to Access 97 Database

By micha805 ·
I have an Access 97 database of which I published a web-based form deployed through the Intranet for data-entry purposes. I have run into the problem of users editing the existing records.

I want the form to open in Add mode so the end-users can only input into the database and not see any existing data. Is this possible in Access 97?

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Comments

Collapse -

by theSage In reply to Web Interface to Access 9 ...

Try using a technique known as an unbound form. The data entry fields on the form are stored as local variables. When the user selects the "save" option, then establish your RecordSet in Add Mode and move the variables into the corresponding fields.

This is a tried and tested method of "remote data entry" and works with front-ends for middle-ware to main frames, web-based applications, and any other form of client/server data entry.

What you are currently trying is known as a "bound-form". You are trying to enter data directly into the RecordSet fields. This is a good technique; however, you are limited by the way the Data Control you are using functions. Using the local variables and th unbound technique gives you more control of the situation. You do have to write a little more code when using this technique; however, then benefits, in your situation, are worth it.

Collapse -

by Ed Woychowsky In reply to Web Interface to Access 9 ...

Yes, it is possible. In early 2000 I used a classic ASP front-end to both allow for data entry and to only show existing data. Whether or not a user can enter information is all based upon the attributes for the input tags, use the disabled attribute or the readonly attribute. The difference is that information displayed with disabled will, by default be gray.

Back to Web Development Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums