Access Trusted Location

[Jimruns919]

I created a database and saved a copy onto a network location. I can add that location for the user as a trusted location and it will open without any errors, but that is where the issue begins.

Nothing runs unless I open it in design mode, then I can run it in view mode.

I have it set to when it opens it goes directly to a main menu. It works fine on my computer off my network copy when I open it. But when I tested it for a user it will not run.



I have to open the menu form in design mode then I can run it in view mode. Reports will not run unless I open them in design mode then they will run.

I have been working on this for a few days and I am not anywhere closer to getting this to work.

All the users have the full MS Access on their computers and since I have the full program I cannot install runtime so any help with this would be appreciated.

[mike60smart]

Hi Jim

Are you saying that all users are using the FE stored on the Network Drive?

What you should have is all users should have a Copy of the FE stored on there own PC in a Trusted Location

They should then have a Shortcut on their desktop to the Copy of the FE

[Jimruns919]

Hi Jim

Are you saying that all users are using the FE stored on the Network Drive?

What you should have is all users should have a Copy of the FE stored on there own PC in a Trusted Location

They should then have a Shortcut on their desktop to the Copy of the FE

For testing I have not even split the database yet. I have the database open without any errors but the default form does not open and nothing opens until you open the form or report in design view then it will run the forms. Then you have to open the reports in design view then the reports will run.

I cannot figure it out but I figure if I can have the copy of the file run on the network location then I can get the FE to run when I split it.

it will not even run if I copy the file to their desktop. It still has to go into design view first. I cannot figure this out.

[mike60smart]

Can you upload a copy of the Db to see if we get the same problem?

[Gicu]

You and all the users are having the same version of Access? Have you checked the VBE window on the user computer for any missing references? I would suggest you decompile the application, run a compact and repair then compile it and give it a try. This assume of course the trusted locations are set up properly.

Cheers,

[Jimruns919]

You and all the users are having the same version of Access? Have you checked the VBE window on the user computer for any missing references? I would suggest you decompile the application, run a compact and repair then compile it and give it a try. This assume of course the trusted locations are set up properly.

Cheers,

Most do. We have either 2016 or 2019 but the version is a 2007-2016 file format.

[Jimruns919]

Can you upload a copy of the Db to see if we get the same problem?

I would be happy to but I do not know how to upload a file here.

[Jimruns919]

Yes. You can see it... https://drive.google.com/drive/folde..._X?usp=sharing

The file size was too big

[Micron]

click "How to attach files" at the top of the forum page

[mike60smart]

Hi Jim

Sorry to say but your table structures are all wrong.

You only need 1 table to record the weekly camps attended.

Your Relationship Diagram is attached for those interested.

[Jimruns919]

This was my first database I wrote.

I believe I did it this way to assist with queries but I taught myself Access in 3 weeks and this was what I did and it does work, but I definitely see how, after writing more databases how this is not ideal.

But you think the relationships are what is causing only me to be able to open and run the file? I can run it on my desktop or my work laptop or my personal laptop, but no one else can.

[Gicu]

You say in your original post that you

have it set to when it opens it goes directly to a main menu

, yet the sample you shared has no AutoExec macro and no opening form set in the Options\Current Database menu:

See if this one opens as expected.

Cheers,

[mike60smart]

You have also set all of the relationships as 1 to 1 ??

[Jimruns919]

You say in your original post that you , yet the sample you shared has no AutoExec macro and no opening form set in the Options\Current Database menu:

See if this one opens as expected.

Cheers,

That worked! What did I do wrong on mine, if I may ask

[Gicu]

Its all in the screen shot, I have set the Display Form to MainMenu_FRM as it was set to None. To set the opening form you can use this property if the database file or you can use an AutoExec macro (https://support.microsoft.com/en-us/...8-a4755e548124).

Cheers,