mcdonlu
asked on
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.
Thanks in Advance.
Why not use the BDE to connect to Access?
ASKER
Edited text of question.
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.
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.
ASKER
Edited text of question.
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\DAO30 32.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.
The real problem is not being able to find the IDAPI Service Library (C:\winnt\msapps\DAO\DAO30
If Access is installed then these files are missing and you should reinstall Access with all options turned on to do with exporting, etc.
ASKER
Edited text of question.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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!
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
http://www.cybermagic.co.nz/winsoft/dao.htm
get this commercial replacement, trial also available, easy to connect to access 2000 and fast
meikl
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.
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