Solved

Data Access Pages - Access 2003

Posted on 2012-03-13
6
608 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

This article will show you how to use shortcut menus in the Access run-time environment.
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

773 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