Data Access Pages - Access 2003
Posted on 2012-03-13
I've been asked to set up data access pages for a client who requires users to be able to modify his database on his intranet. We cannot use a fe-be setup as most of the pc's available will not have access or a runtime version of access installed.
I agreed DAP seemed like the easiest method to achieve this, it will be a very small insertion of data to be sent to the database. I am very experienced in access however it's been a few years since I touched DAP and on just trying it on my own system I am not having any luck.
I am running access 2002 on an XP machine and when I try to create a DAP using the wizard I get through all the options and right at the very end I see 'The wizard is unable to create your data access page.'
If I try to create a new DAP in design view I get a different message 'The OLE server isn't registered. To register the OLE server, reinstall it.'
Not sure what that means, I want to try and get this ironed out so I am well versed in what I am doing before visiting the client on site.
I'd like to avoid having to write pages myself in ASP to do this task as the client is a novice user and wants me to show him how to do this himself in the future and I'm not about to try and teach someone that in one day!
Any assistance is much appreciated.