Link to home
Start Free TrialLog in
Avatar of Jim Klocksin
Jim KlocksinFlag for United States of America

asked on

How to connect PowerBuilder 12.1 to MS Access 2010 database?

I've never worked with Access before so this is all new to me (over 20 years working with SQL Server).  I've got a new project that needs to utilize MS Access as the database and I'm trying to learn by using an existing application that I actually converted from Access to SQL Server.  My specific problem is a "Database Connect Error" (I'll attach the exact error message being returned.  My connection parameters I'm trying to use are as follows:

sqloledb_connectstring = "PROVIDER='Microsoft.ACE.OLEDB.12.0',DATASOURCE='D:\DBFiles\PM-JP.accdb',"
sqloledb_connectstring = sqloledb_connectstring      + "ACE OLEDB:System Database='D:\DBFiles\Security.mdw',"
sqloledb_connectstring = sqloledb_connectstring      + "MODE='DB_MODE_READWRITE'"
SQLCA.DBParm = sqloledb_connectstring

I'm not really familiar with workgroup information files, but I followed the wizard in MS Access 2010 to generate the "Security.mdw" file.

Any help would be greatly appreciated, Jim KlocksinUser generated image
ASKER CERTIFIED SOLUTION
Avatar of Jim Klocksin
Jim Klocksin
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jim Klocksin

ASKER

Over-reaction on my part since I have no real experience with MS Access.