How to remove Workgroup Security from a Microsoft Access database

Question

Hello,

I am SQL Server specialist and I have been volunteered to port a Microsoft Access system to SQL Server. Unfortunately, the developer of the Access system is no longer around, and I have no Access experience. The system has Front End and Back End MDB databases and I have already ported the back end tables to SQL Server and the Front End is now linked and working successfully with the migrated SQL Server tables. We are using Active Directory in SQL Server to prevent unauthorised access to the data via the front end.

I now want to get rid of the dependency on the MDW but I am completely lost. I open the database using the following:
C:\Program Files (x86)\Microsoft Office\Root\Office16\MSAccess.exe C:\CARR\Dat\CARR_Dat.mdb /wrkgrp C:\CARR\lib\CARR_sys.mdw /user XXX /pwd YYY

From what I understand, the MDW operates on the Front End MDB file only (is that correct?) and that's where I need to go to get rid of the dependency on the MDW. But, I don't know how to do that. So, I am hoping someon can please point me to a beginner's guide or a good resource that describes how to get rid of dependencies on MDW files. I saw a couple of aritcles that seemed to suggest expoerting and importing the database object to a new database. Is that the recommended approach?

Answer 1

Take a look at:

https://documentation.help/MS-Office-Access-2003/achowRemoveUserlevelSecurityS.htm