Page Feature

Topic

New Reply

Hi, I’m still learning Access but I want to make a webpage with a form that will update the Database, now I want it to work for users who don’t have Access, is this possible? I have played around a little with it and could only get it to work for the one’s that have Access on their computers already.

Reply | Quote

Replies

This is certainly possible. You could use a data access page constructed in Access. (Look up help and type in Data Access Page – you will get a number of references.

There is a comment on one of these that “users who have a Microsoft Office 2000 license can update data over the Internet or an intranet” This may well be a misprint and should perhaps read “Users who do not have… ”

I think all you need to use the page is IE5 or later.

The place where the page is located is important. It must be accessible to the proposed users and must be able to link to the database. This may cause problems in a corporate environment.

The permissions for the database and record locking will also need to be thought about. If one user has the database opened exclusively the Data Access Page will not be able to do much.

I suggest you try to do it using the help files and come back to the forum if you have specific problems.

In the real world, I would suspect a more robust form of front end would be used. If you wanted to set up Amazon.com you might need to think about alternative solutions, but if you will not have a large number of simultaneous users Data Access Pages may suit you.

Warning. Not based on exhaustive experiment.

Reply | Quote

Sorry, but data access pages are Access 2000-specific and require Office 2000.

Reply | Quote

So is there another way to accomplish what I want to do? I just want users to be able to report problems in a form and have that information stored automatically in the database. These users won’t have Access though. I use Access 2000.

Reply | Quote

What you want to do is possible. You will need to store the .mdb file on a web server and write a simple front end for the users to update the table.

The front end however can’t be created in Access you’ll need to use ASP or Java or something along these lines.

The version of Access probably wont matter as Access in this instance will only be the data store.

Regards
Carolyn

Reply | Quote

Oh boy am I in trouble then as I don’t have any idea what ASP is and very limited knowledge of Java, anyone know where I can go to learn this stuff???

Reply | Quote

There is a very simple wizard in Front Page 2000 that allows you to view records from an Access database. I haven’t played with it much, but I’m fairly certain that you can edit data with it also.

HTH

-MarkJ-

Reply | Quote

Thanks Charlotte. How odd.

Sultan – I apologise for misleading you.

Reply | Quote

In my opinion, data access pages are toys that Microsoft stuck in there to suck developers into its more powerful (and expensive) web-related technology. They work fine on an intranet where everyone has Access, but that’s about all they’re intended for except getting your feet wet in the web.

Reply | Quote