CDaoDatabase for Opening MS-Access
-
Hi i have developed an tool which writes data into the MS-Access file (Eg: empdata.mdb which exist in remote pc). - Certainly this exe will run in many machine across network( Approxmatively 30 machines) When i run the exe in diffrent machines (windows 7) it giving the following error. "It is already opened exclusively by another user , or u need permission to view its data." Could anyone help in resolving the issues. Thanks & Regards Mani
-
Hi i have developed an tool which writes data into the MS-Access file (Eg: empdata.mdb which exist in remote pc). - Certainly this exe will run in many machine across network( Approxmatively 30 machines) When i run the exe in diffrent machines (windows 7) it giving the following error. "It is already opened exclusively by another user , or u need permission to view its data." Could anyone help in resolving the issues. Thanks & Regards Mani
The error message indicates that the database has been opened by another application with exclusive access or the user hasn't sufficient privileges to access the database file. When using the
CDaoDatabaseclass, passFALSEas second parameter to theOpen()function. When using Access, it must be configured to open files in shared mode (this is the default). The database file must be readable and writable for the users. See also Ways to share an Access database[^].