Module problem in MDE

[RossG]

I have a database, split into Back & Front ends and using a workgroup, which I want to convert to an MDE.

Problem is that when I do that I am the only person that can log in, presumably because I am the database owner.

When anyone else logs in they get an error saying they don't have permissions on MSysModule2.

If I recall properly these MSys files are hidden. How the heck do I find them, and what sort of permissions are needed? As I said, this only affects the MDE version, the MDB's run fine.

 

[ElsVanMiert]

I do not think that the ownwership is the reason for your problem.

I suppose that you are calling a function from the autoexec-macro or in the startup form and this function tries to modify (invisibly) one of the system tables.

This function might be a refreshlink or something like that (you need administrator rights to refresh the links!).

Just de-activate the function and the non-administrator users will be able to work with the MDE.

 

[RossG]

Thank you Els!

You were spot on! I had a function that checked the linked table was still present in the correct directory, then offered a search option if it wasn't.

Now the project has 'matured' a bit I don't really need that function anymore, so it's been a positive outcome!

By the way, as a 'junior' member of this forum I've found it to be a fantastic source of info and tips. A big THANK YOU to everyone who administers and contributes to the forum!