Access 2010 Database connection

Archived support forum for customers who once purchased a PrimalForms product license. This forum is locked.
This topic is 11 years and 4 days old and has exceeded the time allowed for comments. Please begin a new topic or use the search feature to find a similar but newer topic.
User avatar
hectoritnt@yahoo.com
Posts: 1
Last visit: Fri Mar 15, 2013 7:02 am

Access 2010 Database connection

Post by hectoritnt@yahoo.com »

I have this form in an Access 2010 Database (.accdb) that I would like to convert into a Powershell script with PrimalForms.
The Database Browser seems to only know about .mdb access files.
Is there a way to update the system to recognize the newer versions of the Access DB?

The form is used to create new printer queues on multiple servers based on the input and then track their usage.

Any help will be greatly appreciated.

Hector
User avatar
davidc
Posts: 5913
Last visit: Mon Jul 08, 2019 8:55 am
Been upvoted: 2 times

Re: Access 2010 Database connection

Post by davidc »

Right now you will have to manually script the connection in the form. We will look into adding support for Access 2010.

Thank you for the request.

David
David
SAPIEN Technologies, Inc.
User avatar
davidc
Posts: 5913
Last visit: Mon Jul 08, 2019 8:55 am
Been upvoted: 2 times

Re: Access 2010 Database connection

Post by davidc »

Actually you can create a OLEDB connection the Access 2010 database. You just have to provide the correct connection string:

"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Northwind.accdb;Jet OLEDB:Database Password=<password>;"

Though if this is a 64bit only provider then you will not be able to connect using the Database Browser since the application is only 32bit. Note: You still will be able to connect to the database in 64bit scripts.

David
David
SAPIEN Technologies, Inc.
This topic is 11 years and 4 days old and has exceeded the time allowed for comments. Please begin a new topic or use the search feature to find a similar but newer topic.