Solved

Data Access Pages - Access 2003

Posted on 2012-03-13
6
607 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

895 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now