Unrecognized Database (Access ACCDB)
Quote from agilefalcon on November 30, 2018, 7:33 amWhen I try to add a record to my Access database, I get an "unrecognized format" error message.
I created the database in MS Access for Office 365 (16.0.11001xxxx) and have just two tables in it.
The command I am using is: dbpAddRecord "MEDS1" "Contacts"
Any ideas why this database won't work?
Chris
When I try to add a record to my Access database, I get an "unrecognized format" error message.
I created the database in MS Access for Office 365 (16.0.11001xxxx) and have just two tables in it.
The command I am using is: dbpAddRecord "MEDS1" "Contacts"
Any ideas why this database won't work?
Chris
Quote from luishp on November 30, 2018, 8:06 amYou should be able to open just about any kind of database with the generic dbpOpenDatabase action as long as the drivers are installed on your PC. You just have to figure out the correct connection string. dbpOpenAccessDatabase just has the MS Access connection string hard coded. Otherwise, it does the same thing as dbpOpenDatabase.
More info about connection strings here: https://www.connectionstrings.
com/access/ Regards.
You should be able to open just about any kind of database with the generic dbpOpenDatabase action as long as the drivers are installed on your PC. You just have to figure out the correct connection string. dbpOpenAccessDatabase just has the MS Access connection string hard coded. Otherwise, it does the same thing as dbpOpenDatabase.
More info about connection strings here: https://www.connectionstrings.
Regards.
Quote from agilefalcon on December 4, 2018, 7:17 amI have some progress. I got passed the "unrecognized format" error - by creating a new database from scratch rather than using one of Microsoft's template databases. Now, my issue is that I am receiving an "Invalid Database ID: MEDS1"
MEDS1 is my database id created with the following:
dbpOpenAccessDatabase "MEDS1" "[PubDir]MEDSNew.accdb" ""
This is the first line where I get the error:
dbpAddRecord "MEDS1" "Contacts"I have used the Database ID Browser and Advanced file options to substitute the drive path with the variable [PubDir]. I don't really see why the error is occurring - it all looks correct. I am opening the table before trying to Add a the record where I get the invalid ID error, though nothing in the Help says that I need to do that for the "dbpAddRecord"
Quick Note: I found that I am getting the "Invalid Database ID:" when the dbpOpenTable action command executes. I even created a new DB ID using the various tools in Object Properties and refreshed the substitution of drive path with [PubDir] and so forth.
Chris.
I have some progress. I got passed the "unrecognized format" error - by creating a new database from scratch rather than using one of Microsoft's template databases. Now, my issue is that I am receiving an "Invalid Database ID: MEDS1"
MEDS1 is my database id created with the following:
dbpOpenAccessDatabase "MEDS1" "[PubDir]MEDSNew.accdb" ""
This is the first line where I get the error:
dbpAddRecord "MEDS1" "Contacts"
I have used the Database ID Browser and Advanced file options to substitute the drive path with the variable [PubDir]. I don't really see why the error is occurring - it all looks correct. I am opening the table before trying to Add a the record where I get the invalid ID error, though nothing in the Help says that I need to do that for the "dbpAddRecord"
Quick Note: I found that I am getting the "Invalid Database ID:" when the dbpOpenTable action command executes. I even created a new DB ID using the various tools in Object Properties and refreshed the substitution of drive path with [PubDir] and so forth.
Chris.
Quote from luishp on December 4, 2018, 7:54 amHi Chris,
Please use dbpOpenDatabase instead of dbpOpenAccessDatabase and let me know if it works.
To connect to your database use the appropiate connection string:https://www.connectionstrings.com/access/
Best regards.
Hi Chris,
Please use dbpOpenDatabase instead of dbpOpenAccessDatabase and let me know if it works.
To connect to your database use the appropiate connection string:
https://www.connectionstrings.com/access/
Best regards.
Quote from agilefalcon on December 4, 2018, 9:20 amHello Luis,
I did that with
"dbpOpenDatabase "S1" "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\cgber\Documents\NeoBook 5\NeoBook Programs\Prescription Tracker\MedsNew.accdb;Persist Security Info=False"
...and tested the connection with success. The database ID refreshes when I use the Insert Action command for dbpOpenDatabase - so all good there.
One thing - when using the Insert Action, it copies the field names and so forth to the clipboard; however, they can't be pasted anywhere as it just shows up as text filling the Rectangle. I've pasted into my editor and have seen the fields and variable names. I made sure the variable names matched my own Text Input boxes such as [S1.Contacts.FirstName] (ID.Table.Fieldname).
I still get the "Invalid Database ID: S1" (because I changed the IDs to see if everything refreshed with the new connection string. That all seems to be working.
It's late for me now - so I'll try again tomorrow...
Chris.
Hello Luis,
I did that with
"dbpOpenDatabase "S1" "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\cgber\Documents\NeoBook 5\NeoBook Programs\Prescription Tracker\MedsNew.accdb;Persist Security Info=False"
...and tested the connection with success. The database ID refreshes when I use the Insert Action command for dbpOpenDatabase - so all good there.
One thing - when using the Insert Action, it copies the field names and so forth to the clipboard; however, they can't be pasted anywhere as it just shows up as text filling the Rectangle. I've pasted into my editor and have seen the fields and variable names. I made sure the variable names matched my own Text Input boxes such as [S1.Contacts.FirstName] (ID.Table.Fieldname).
I still get the "Invalid Database ID: S1" (because I changed the IDs to see if everything refreshed with the new connection string. That all seems to be working.
It's late for me now - so I'll try again tomorrow...
Chris.
Quote from luishp on December 4, 2018, 10:50 amAre you using VisualNEO Win and NeoDBpro, or NeoBook and NeoBookDBpro?
It's important because there are some incompatibilities, just use the correct match:
- NeoDBpro for VisualNEO Win.
- NeoBookDBpro for NeoBook.
Let me know if you have success.
Regards,
Are you using VisualNEO Win and NeoDBpro, or NeoBook and NeoBookDBpro?
It's important because there are some incompatibilities, just use the correct match:
- NeoDBpro for VisualNEO Win.
- NeoBookDBpro for NeoBook.
Let me know if you have success.
Regards,
Quote from agilefalcon on December 4, 2018, 5:40 pmI didn't realize there were differences:
Neobook V5.8.7 - 23 January, 2016
And the latest version of NeoDBPro (that I purchased from your site).
So, that perhaps is the issue?
Chris.
I didn't realize there were differences:
Neobook V5.8.7 - 23 January, 2016
And the latest version of NeoDBPro (that I purchased from your site).
So, that perhaps is the issue?
Chris.
Quote from agilefalcon on December 4, 2018, 6:22 pmLuis,
That was the issue! I downloaded "VisualNeo Win" and installed it after removing my "NeoBook" application.
I really like this tool and the fact that you have picked it up - so I will go now and purchase it from your store. It is well worth the money! - Update: Just purchased VisualNeo and the NeoFM-FTP plugin.
Thank you for your support too!
Chris
Fort Worth, Texas
USA
Luis,
That was the issue! I downloaded "VisualNeo Win" and installed it after removing my "NeoBook" application.
I really like this tool and the fact that you have picked it up - so I will go now and purchase it from your store. It is well worth the money! - Update: Just purchased VisualNeo and the NeoFM-FTP plugin.
Thank you for your support too!
Chris
Fort Worth, Texas
USA
Quote from luishp on December 4, 2018, 8:31 pmThank you Chris :)
You are very welcome.
I have just sent you the Registration Keys.
Best regards.
Thank you Chris :)
You are very welcome.
I have just sent you the Registration Keys.
Best regards.
Quote from edwards on July 22, 2020, 8:48 am
Well, this problem of Access unrecognized database format error can easily be resolved after converting your database to an earlier database format. It’s been so easy to perform this:
- Go to your Access database and tap to the Tools.
- Choose Convert Database option from the appearing list.
- Now it’s time to choose the tab for accessing the file format.
- Assign a name to your database.
- At last hit the save option to save all the changes.
Well for more reference you can check out these blogs on Convert MDB File To ACCDB or Convert ACCDB File To MDB
Well, this problem of Access unrecognized database format error can easily be resolved after converting your database to an earlier database format. It’s been so easy to perform this:
- Go to your Access database and tap to the Tools.
- Choose Convert Database option from the appearing list.
- Now it’s time to choose the tab for accessing the file format.
- Assign a name to your database.
- At last hit the save option to save all the changes.
Well for more reference you can check out these blogs on Convert MDB File To ACCDB or Convert ACCDB File To MDB
Quote from ragman on July 24, 2020, 4:19 amEstimados,
para solucionar este problema yo uso AccessDatabaseEngine.exe (versión en español, y de 32bit office 2010), lo puede usar con o sin office en el equipo a utilizar, es compatible con todas las versiones de office posteriores a la 2010.
Saludos
Richard Ramirez
Estimados,
para solucionar este problema yo uso AccessDatabaseEngine.exe (versión en español, y de 32bit office 2010), lo puede usar con o sin office en el equipo a utilizar, es compatible con todas las versiones de office posteriores a la 2010.
Saludos
Richard Ramirez
Quote from neodude2 on October 18, 2020, 3:28 pmYou can automatically download & install access drivers (AccessDatabaseEngine.exe) on your own and your clients' computers.
I have attached sample code.You can even detect unrecognized format error (with the help of [dbpError] variable) and use If..Then..Else to automatically install access driver on your clients' computers.
You can automatically download & install access drivers (AccessDatabaseEngine.exe) on your own and your clients' computers.
I have attached sample code.
You can even detect unrecognized format error (with the help of [dbpError] variable) and use If..Then..Else to automatically install access driver on your clients' computers.
Uploaded files:
- You need to login to have access to uploads.