Support Forums

Access 2010 Database connection

Archived support forum for customers who once purchased a PrimalForms product license. This forum is locked.
User avatar
hectoritnt@yahoo.com
Posts: 1
Joined: Sun Mar 03, 2013 12:40 pm

Access 2010 Database connection

Postby hectoritnt@yahoo.com » Fri Mar 15, 2013 6:53 am

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: 4354
Joined: Thu Aug 18, 2011 4:56 am

Re: Access 2010 Database connection

Postby davidc » Fri Mar 15, 2013 9:42 am

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: 4354
Joined: Thu Aug 18, 2011 4:56 am

Re: Access 2010 Database connection

Postby davidc » Fri Mar 15, 2013 10:44 am

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.

Return to “PrimalForms”

Who is online

Users browsing this forum: No registered users and 1 guest