2

We use in a company an Access database which I developed a long time ago with front end and back end .mdb files and user level security. (We don't need high security standards)

Now I am developing an extension to that database which is mostly independent but has to access some tables of the backend mdb file with user level security.

Is it possible to setup linked tables in an accdb file to a mdb file with user level security? (I tried and it seems it does not work)

If not, is there a big disadvantage to convert a half developed .accdb database into a .mdb database so that it's possible to access the .mdb file with user level security?

Edgar
  • 2,527
  • 2
  • 19
  • 40
  • 1
    Disadvantage to conversion is some features utilized in accdb will not be backwards compatible. – June7 Aug 22 '19 at 05:27

1 Answers1

1

Start the access application with a custom shortcut and add the /workgroup swtich that specifies the path to the workgroup file. This then should allow you to freely link + consume to the linked mdb file.

Albert D. Kallal
  • 42,205
  • 3
  • 34
  • 51
  • I confirm this works. Thanks a lot! My shortcut looks like this: "C:\Program Files (x86)\Microsoft Office\Office16\MSACCESS.EXE" "D:\Data\NewDb.accdb" /wrkgrp "D:\Data\OldSecurityFile.mdw" – Edgar Aug 24 '19 at 03:13