NeoDBPro - connect to Access difficulties
Quote from nichjoht on November 22, 2019, 11:16 pmTrying to connect to an Access DB that is local and contains an empty table. When the application runs I attempt to open the DB but get an error: dbpError=Provider cannot be found. It may not be properly installed
I have reinstalled Access but still, get the same error.
The final goal is to import a CSV file and populate the empty table with the data.
Please help.
Best regards,
John Nicholson.
Trying to connect to an Access DB that is local and contains an empty table. When the application runs I attempt to open the DB but get an error: dbpError=Provider cannot be found. It may not be properly installed
I have reinstalled Access but still, get the same error.
The final goal is to import a CSV file and populate the empty table with the data.
Please help.
Best regards,
John Nicholson.
Quote from luishp on November 23, 2019, 10:37 amThat's quite strange. Access DB connection should work even if you have not Microsoft Access software installed. The driver comes with Windows OS. Are you opening the database as described here?:
https://neodbprohelp.visualneo.com/OpeningaDatabase.htmlRegards.
That's quite strange. Access DB connection should work even if you have not Microsoft Access software installed. The driver comes with Windows OS. Are you opening the database as described here?:
https://neodbprohelp.visualneo.com/OpeningaDatabase.html
Regards.
Quote from Gaev on November 23, 2019, 5:34 pm@nichjoht
1) The plugin comes with a few sample pubs ... AddressBook, DatabaseViewer, OrderEntry etc. ... see if you can run these.
2) If they run without problems, examine the script within them to see if your method of opening the Access Database is different from those in the samples.
3) If not, see if you can open another database (created/edited with your Access program) using your pub/plugin.
4) If you can, see if you can open your Access DB from the pub/plugin AFTER you add a single record in the database (using your Access program)
Post your results here.
1) The plugin comes with a few sample pubs ... AddressBook, DatabaseViewer, OrderEntry etc. ... see if you can run these.
2) If they run without problems, examine the script within them to see if your method of opening the Access Database is different from those in the samples.
3) If not, see if you can open another database (created/edited with your Access program) using your pub/plugin.
4) If you can, see if you can open your Access DB from the pub/plugin AFTER you add a single record in the database (using your Access program)
Post your results here.
Quote from nichjoht on November 25, 2019, 5:49 amThanks so much for the quick reply. I looked at the example apps and saw I was doing everything right. This helped me narrow down the possibilities and find the root of the problem.
Originally I created and saved the DB with the "accdb", as soon as I converted the DB to an older version of Access DB, an "mdb" the app worked perfectly. I found this to be the case for versions 2000 and versions 2002-2003 of "mdb".
Once again thanks for the help. :)
Thanks so much for the quick reply. I looked at the example apps and saw I was doing everything right. This helped me narrow down the possibilities and find the root of the problem.
Originally I created and saved the DB with the "accdb", as soon as I converted the DB to an older version of Access DB, an "mdb" the app worked perfectly. I found this to be the case for versions 2000 and versions 2002-2003 of "mdb".
Once again thanks for the help. :)
Quote from PaulJonestindall on November 25, 2019, 12:38 pmI have the same issue with NeoBookDBPro. But my problem is with accdb files. The documentation suggests the dbpOpenAccessDatabase action should be able to work with both MDB and ACCDB files. I understand I have to install some additional Microsoft software but I'm not sure what to be able to take advantage of the ACCDB files.
I have the same issue with NeoBookDBPro. But my problem is with accdb files. The documentation suggests the dbpOpenAccessDatabase action should be able to work with both MDB and ACCDB files. I understand I have to install some additional Microsoft software but I'm not sure what to be able to take advantage of the ACCDB files.