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.O
sqloledb_connectstring = sqloledb_connectstring + "ACE OLEDB:System Database='D:\DBFiles\Secur
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 Klocksin