Good way of Interacting with MS Access from a web page

smde
smde used Ask the Experts™
on
Can anyone suggest a good method to Add/Edit/Delete MS Access information from a MS Acess DB on a web page.  
links , ??? or code examples .. appreciated...
 Thanks

 
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
you have a host of possibilities ... do you want performance, low or no cost, what environment are you working with?

thomasdodds

Author

Commented:
I am working in Internet explorer on an NT or windows server - there are relatively few hits on the web page and very little chance of many simulataneous hits ( on an intranet).

I am not so familiar with MS Access.

I am hoping that I can post info directly to the MS Access database from a web page using server side - Perl scripts or VB and read real-time (more than less) from the MS Access database ands display data as need from (basic queries, etc )
I am hoping that there are already perl libs or VB scripts that can do this directly from a web page so it would not be necessary to develop all the functionality from scratch.
Thank you , in advance , for your response to this question.
ASP & ADO - MS technologies for you MS environment...

http://www.asp101.com/samples/ might help you in starting out

since everyone's database is different you might have to work most of it out on your own -- I haven't done a concentrated search for existing code to do it either

thomasdodds
Angular Fundamentals

Learn the fundamentals of Angular 2, a JavaScript framework for developing dynamic single page applications.

Commented:
If you have FrontPage, you can do it the sneaky way... open your web in FrontPage, double click on the Access database, and FP will copy it over to your machine, where you can do whatever you need, and then copy it back to the server when you close Access. No FTP, no hassles. However, you must have the same version of Access on your machine.

That doesn't do anything about showing the records in the database though. Just the add/delete/modify part. For showing/searching the records, you'll need those tutorials/samples on www.asp101.com ;-)

DO NOT even think about using ANY of the FP database connection wizards or Access web tools. Not only are they exceedingly limited (and limiting), but they break for no apparent reason.

Besides, if you learn how to do it yourself in ASP, you'll be able to do pretty much anything you might want to.
If you are not inclined to do the coding yourself and you have the capability for ASP (Active Server Pages) you might want to look at Generic DB.
 
http://www.genericdb.com/genericdb/homepage.asp

Open source and a nice little ASP web database engine.

Author

Commented:
Is ASP a difficult thing to enable on a server - I am familiar with VB and programming just not vary informed about how to enable ASP on a Windows or NT netscape web server.
See:

 http://www.webmasterbase.com/article/371/10

for the basics on enabling ASP on NT, Win 95 or Win98.

Commented:
Your comment "enable ASP on a windows or NT netscape web server" shows inexperience in the matter. Windows uses I.I.S. as it's native web server. I.I.S. has native support for ASP. Coding ASP uses a mixture of vbscript (or you can use javascript if you tell it to) and ASP code. There is quite a lot of programming if you go down this road. From your posts I would suggest you use FrontPage with Extensions enabled. I tend to agree with webwoman about the flakiness of doing it with FrontPage but if you are patient you can get it to work pretty reliably.
If you want to use Perl / cgi, again prepare for some programming and back end set-up. Check out Matts Script Archive [ http://www.scriptarchive.com/ ] for a good starting point.
Top Expert 2013

Commented:
This question has been abandoned. I will make a recommendation to the
moderators on its resolution in a week or two. I appreciate any comments
that would help me to make a recommendation.
<note>
   In the absence of responses, I may recommend DELETE unless it is clear
   to me that it has value as a PAQ.  Silence = you don't care
</note>

Cd&
Top Expert 2013

Commented:
It is time to clean this abandoned question up.

I am putting it on a clean up list for CS.

<recommendation>
points to thomasdodds

</recommendation>

If anyone participating in the Q disagrees with the recommendation,
please leave a comment for the mods.

Cd&

per recommendation

SpideyMod
Community Support Moderator @Experts Exchange

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial