[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Data Access Pages - Access 2003

Posted on 2012-03-13
6
Medium Priority
?
630 Views
Last Modified: 2012-08-14
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.
0
Comment
Question by:daz84
  • 4
  • 2
6 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37717113
Not sure, what OS are you running..?
What version of Access are you running

As you know DAP were deprecated in native access 2007 format DB's (.accdb)
So if you want to create a DAP, then you need to save the DB in the 2003 format. (.mdb)
0
 
LVL 2

Author Comment

by:daz84
ID: 37719378
It is windows XP and Access 2002, it is an old file which has always been an mdb. If I was in a newer version I wouldn't even get as far as I did as the pages wizard would not be available
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37719782
OK, then please wait for another Expert, or see what Google has to say...
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
LVL 2

Author Comment

by:daz84
ID: 37719916
I spent about an hour on google before posting here, it's full of guides and walkthroughs of how to set up DAPs, setting them up would be easy I know how to do that, but it isn't working and the error messages are not useful in helping me find out why. Any trouble shooting sites I try all just direct me to sharepoint which is not what I want.
0
 
LVL 2

Accepted Solution

by:
daz84 earned 0 total points
ID: 37720393
After a significant amount of digging I found the culprit, triedit.dll was corrupt, downloaded a fresh version from microsoft, registered it and all was well.

Thanks for the reply and sorry if I wasted anyones time!
0
 
LVL 2

Author Closing Comment

by:daz84
ID: 37736775
Problem solved!
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Implementing simple internal controls in the Microsoft Access application.
In this article, I will demonstrate that how to do a PST migration from Exchange Server to Office 365. This method allows importing one single PST, or multiple PST's at once.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
There may be issues when you are trying to access Outlook or send & receive emails or due to Outlook crash which leads to corrupt or damaged PST file. To eliminate the corruption from your PST file, you need to repair the corrupt Outlook PST file. U…

591 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question