sjc2309
asked on
Web page to update Access Database
Hi all
How do I create a web page that adds and updates entries in a MS Access database? The idea is to use an online form on that web page where information is inputted and than added to the database.
Thanks,
seb
How do I create a web page that adds and updates entries in a MS Access database? The idea is to use an online form on that web page where information is inputted and than added to the database.
Thanks,
seb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
why not use the use the data access pages available in ms access to create the inout form.
No problem with doing this except I have run into permission problems for external users. The form works great and add tremendous features rather quickly. If this is on an Intranet then I say go for it but if you plan on publishing this externally then I caution you on this.
You also have very little design control over this process. All of your design has to be done in Access and this is not a web development tool.
You may also have to adjust your security settings in IE to allow this to perform correctly.
Just some thoughts on the process. Personaly I am much more comfortable in creating in FrontPage or ASP to give me complete control over the process.
RCMB
You also have very little design control over this process. All of your design has to be done in Access and this is not a web development tool.
You may also have to adjust your security settings in IE to allow this to perform correctly.
Just some thoughts on the process. Personaly I am much more comfortable in creating in FrontPage or ASP to give me complete control over the process.
RCMB