Help needed connecting to a MS Access DB via ADO
Posted on 2006-11-11
I am using Delphi 6 and connecting to an MS Access 2003 database file.
I basically have written an install program which installs the needed files (so I think ???) to run the application - the database mdb file, the Application exe, an ini file and the following qtintf.dll ??.
The install works and the application runs on my pc (which it should), but when I go to install it on another pc, and then run it - a login dialog appears asking for an admin password.
I have checked other questions and answers within EE, and have set login prompt to False, User ID ="", set the database password etc...., but still cannot get the application to run. It appears to only happen on pc's that do not have MS ACCESS installed ?
I thought that Windows XP SP2 should have relevant drivers - MDAC etc.. required.
I am wanting to Secure the MS Access database file so that it cannot be copied and open via MS Access, and only opened via my Application via my login dialog.
Any urgent help would be greatly appreciated.