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 KlocksinAccessConnectionErrorMsg.jpg
Jim KlocksinOwner, Data ArchitectsAsked:
Who is Participating?
Jim KlocksinConnect With a Mentor Owner, Data ArchitectsAuthor Commented:
Never mind.....I realized that I had a parameter defined for SQL Server that should NOT have been set in order to access MS Access databases.  So this "question" is closed from my perspective.  Since I'm new to Access, I may have other questions before I complete this project, as of now, everything is OK!   Sorry about that!
Jim KlocksinOwner, Data ArchitectsAuthor Commented:
Over-reaction on my part since I have no real experience with MS Access.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.