Page 1 of 1

Access 2010 Database connection

Posted: Fri Mar 15, 2013 6:53 am
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

Re: Access 2010 Database connection

Posted: Fri Mar 15, 2013 9:42 am
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

Re: Access 2010 Database connection

Posted: Fri Mar 15, 2013 10:44 am
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