Hi all! I'm an access-beginner and have the following problem:
We were using Access 2003 with an ODBCDirect database and upgraded to Access 2010 recently. After the upgrade I received an error message that ODBCDirect isn't supported anymore and that I have to change from DAO to ADO in the corresponding source code parts. After receiving this message I changed the VBA source code of the database connection.
I'm handling the db connection now over an ADODB.Connection object by defining the connectionString and not using ODBCDirect objects anymore. Now I'm receiving the message "Cannot start your application. The workgroup information file is missing or opened exclusively by another user."
I can't find this workgroup information file anywhere. My colleague told me, that they never used such a file.
My database has the type .mdb.
How can I create a new workgroup information file in Access 2010?
I found several tutorials in forums but none of them is applicable to my problem.
For example.. I have no tools/security menu and also no WorkgroupAdministrator settings in my Access2010 ... or it is hidden very well in the new menu layout of Access 2010.
Thanks for reading
AccJohn
We were using Access 2003 with an ODBCDirect database and upgraded to Access 2010 recently. After the upgrade I received an error message that ODBCDirect isn't supported anymore and that I have to change from DAO to ADO in the corresponding source code parts. After receiving this message I changed the VBA source code of the database connection.
I'm handling the db connection now over an ADODB.Connection object by defining the connectionString and not using ODBCDirect objects anymore. Now I'm receiving the message "Cannot start your application. The workgroup information file is missing or opened exclusively by another user."
I can't find this workgroup information file anywhere. My colleague told me, that they never used such a file.
My database has the type .mdb.
How can I create a new workgroup information file in Access 2010?
I found several tutorials in forums but none of them is applicable to my problem.
For example.. I have no tools/security menu and also no WorkgroupAdministrator settings in my Access2010 ... or it is hidden very well in the new menu layout of Access 2010.
Thanks for reading

AccJohn