[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 225
  • Last Modified:

MSACCESS Conection Problems

I've searched the MSACCESS Install disk and can find no trace of the dll at all. I am running OFFICE 2000 though...do you think that this may be the problem? Possibly the dll has changed and delphi is still searching for the 95 or 97 dll?


Thanks in Advance.
0
mcdonlu
Asked:
mcdonlu
  • 5
  • 4
  • 2
1 Solution
 
kretzschmarCommented:
hi mcdonlu,

i guess its a configuration problem of your odbc driver or your native-driver, therefore i ask you, can you provide a bit more information, how you has configured your driver?

also the error message might point, to a duplicate(or more) choice by the given dns-name.

meikl
0
 
jswebyCommented:
Why not use the BDE to connect to Access?
0
 
mcdonluAuthor Commented:
Edited text of question.
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
jswebyCommented:
In the BDE Admin program, select File|New.

Select MSACCESS as the driver name, not "Microsoft Access Driver (*.mdb)".
Press OK.

Change the DATABASE NAME to your MDB file, LANGDRIVER to "Access General". SYSTEM DATABASE should be the location of system.mdw on your PC. If it's not anywhere to be found, re-install Access as this could be your problem. USER NAME can either be blank or "ADMIN". Try either.

Hope this helps. Go to Help|About in the Admin program to check you're on at least BDE 5.0 to get the most from Access & the BDE.
0
 
mcdonluAuthor Commented:
Edited text of question.
0
 
jswebyCommented:
As for the freezing up, that's a little odd - it is sometimes VERY slow to drop the list down - have you given it a good couple of minutes to allow the list to drop? If you have and still no joy then don't worry about this particularly.

The real problem is not being able to find the IDAPI Service Library (C:\winnt\msapps\DAO\DAO3032.DLL in your case). This file (and others that go with it) are the link between Access and everything else and should have been installed when MS Access was installed on your PC. It is installed, isn't it? If not, then you'll need to find the download for Microsoft DAO drivers, try microsoft.com first.

If Access is installed then these files are missing and you should reinstall Access with all options turned on to do with exporting, etc.
0
 
mcdonluAuthor Commented:
Edited text of question.
0
 
jswebyCommented:
Ah, yes, Office 2000, therefore Access 2000, uses ADO now instead of DAO so any attempt to use drivers for anything less that Access 2000 won't work.

Bit of a pain that!

You either need to:

(1) Go back to using Access 97/98
(2) Use a third-party BDE replacement that deals with ADO (can't think of one though)
(3) Check Borland's website to see if they're planning to support ADO using the BDE.
0
 
mcdonluAuthor Commented:
Thank you for your time and your quick replies. I belive I have enough understanding now to figure out what needs to be done. Thank you agian!
0
 
kretzschmarCommented:
no no no,

http://www.cybermagic.co.nz/winsoft/dao.htm

get this commercial replacement, trial also available, easy to connect to access 2000 and fast

meikl
0
 
jswebyCommented:
Yeah, looks like I jumped the gun there; as long as you're using DAO 3.6 which should have been installed with Access 2000 you should be fine.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now