Command line option /x

[RonAbbott]

Sorry - am a bit lost - that link seems to be if you are working in 2007 with a 2003 database.
I am working only in 2003.


I opened the mdw and found some 'MSys..' queries - can I alter anything in there ?

[RonAbbott]

Sorry - am a bit lost - that link seems to be if you are working in 2007 with a 2003 database.
I am working only in 2003.
I opened the mdw and found some 'MSys..' queries - can I alter anything in there ?

[Gicu]

Here are some links for 2003:
https://documentation.help/MS-Office...lSecurityS.htm
https://social.msdn.microsoft.com/Fo...orum=accessdev

[RonAbbott]

I do appreciate your help with this, but it appears removing the ULS is more work within the secure database than I can afford every time I get another third party database.
All I wanted to do was either link directly into the third party tables, supplying the user name and password from my database, OR import the tables I need into my database.
It seems my best option is to log in to the third party database, import some vba code and a macro, then run the macro to export the tables I need to my database.

[isladogs]

You may be able to use the /user and /pwd command line switches that were designed for use with databases containing ULS.
See my article Access Command Line Switches (isladogs.co.uk)

I don't know whether those switches still work in newer versions of Access running old MDB files