Data access page or ASP

[sharonc]

Can someone tell me is it better to use Data access pages in MS Access or would it be better for me to use ASP to place a MS Access database on the WEB?

 

[assets]

I have only played around with the pages that you create with access. I have had some security issues. I know this does not answer you question, BUT it may generate some comments from others. I have asked wsb question in this area and have not got any responces. To get back to your question the backend would need to be in a DMZ zone for protection. I hope you find the answer as it woud be usefull for other in the future.

 

[MikeRBS]

Read this:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/deploydap.asp

I've spent a bit of time looking at this and I can't find the solution.

Every time you ask a question about DAPs nobody responds, which I can only assume is because they don't use them, which I can only assume is because they don't work.

The other factor is ASP works with any and every browser and pc, whereas DAPs still don't work properly on my workstation which has ostensibly had all the components loaded.

 

[sharonc]

Thank you for replying. I'm going with the ASP page. I noticed that most people that ask questions on DAPs don't receive answers. It sounds like not to many people are using them.

Thanks.

 

[FancyPrairie]

I like DAP better because they are easy to develop (especially if you already know Access), code, and the user gets instant feed back rather than have to submit all their responses at once before they know if the data they entered is correct.

However, version 1 of DAP (Access 2000) is not really suited for the internet because the user must be using Windows Explorer 5.0 and above, and must have Office installed (to access the Microsoft Office Web Components). It works pretty well on an intranet site if your (assuming Office 2000 is installed). Access 2003, on the other hand, is much more friendly to use and does not require Office to be installed on the user's machine. Rather, the Microsoft Office Web Components will be automatically downloaded to the user's machine.

 

[BNPMike]

Access 2003, on the other hand, is much more friendly to use and does not require Office to be installed on the user's machine. Rather, the Microsoft Office Web Components will be automatically downloaded to the user's machine.

I think you still have to have an Office Licence, so it might work alright in some corporate environments but still has entry hurdles.

As for making DAPs available on the Internet - I don't see any forward movement on that.

 

[sharonc]

Thank you for your replys. For now I'll use ASP, but I'll take another look when I get Access 2003. Thanks.

 

[Terpsfan]

If you really are interested creating internet applications I would suggest using ASP.NET. It beats the heck out of using ASP/DAP's, which will eventually become dinosaur technology. Plus you end up using a real programming language instead of the antiquated vb script.

 

[ckaspar]

I have never had any success with DAP's.

Not only that but if the time come you can migrate to MSSQL with no problem if you use ASP.NET, I agree with Omega

Chris Kaspar
Independent Systems and Software

http://www.independentsystemsandsoftware.com

Twin Town Treatment Centers

http://www.twintowntreatmentcenters.com

 

[BNPMike]

As far as I am aware, Data Access Pages work with MS SQL Server.

 

[sharonc]

Thank you for the advice on ASP.Net. I hope to go to it next year. It sounds great.

Thanks.