Solved Forms Not Loading

[Hecronis]

I don't know if this is the correct sub forum for this question.

So I have a database, that multiple people have access to over a VPN. For some people everything works fine, but for others some of the forms will not load. It will just show a blank page for some of the forms. I can put those forms in design or layout mode and all of the objects are there but the objects do not appear if you call it using the buttons. Like I said this is only on some computers not all of them. This is my first attempt at making a DB with multiple front ends, I don't know if that has anything to do with it.

Also when I try to use the DB on this computer that is acting weird, it says that is in Read Only and asks if I would like to save a copy. That never came up on the computers where everything was working.

 

[pbaldy]

Make sure the affected users have write permissions on the folder where the front end is. If not, the lock file can't be created and the db will be read only.

 

[Ranman256]

sometimes, a person has a version of Access, that may have conflicts, be it a REFERENCE or driver difference.
I sometimes have to have different versions of the app because of an Excel reference. 1 person has off15, 1 has off16.
if they enter vbe (alt-F11) then tools, references....there may be MISSING items checked. they will need reference to THEIR version of items.

 

[isladogs]

sometimes, a person has a version of Access, that may have conflicts, be it a REFERENCE or driver difference.
I sometimes have to have different versions of the app because of an Excel reference. 1 person has off15, 1 has off16.
if they enter vbe (alt-F11) then tools, references....there may be MISSING items checked. they will need reference to THEIR version of items.

A better solution for this would be to use late binding for the Excel related code.
Doing that means you don't need an Excel reference at all and would only need one version of your FE

 

[Hecronis]

A better solution for this would be to use late binding for the Excel related code.
Doing that means you don't need an Excel reference at all and would only need one version of your FE

How would I go about doing that?

 

[MajP]

@Hecronis, I think this is confusing. @isladogs was responding to @Ranman256 but a reference issue seems unlikely to be the cause of the problem that the OP is asking about. IMO @pbaldy solution is more likely. I have never ever seen a reference issue cause something like this.

 

[pbaldy]

I have never ever seen a reference issue cause something like this.

Me neither...

 

[isladogs]

Nor me.
As already stated, I was responding to the comments written by @Ranman256

 

[Hecronis]

Update: I changed the permissions on the folder, as suggested, and that fixed the Read Only issue. I also ran a compact and repair on it again and that seemed to clear up the forms not loading.

 

[pbaldy]

Glad it worked for you. Being read only would mean a data entry form would come up blank, as no new record is possible. More here:

Microsoft Access tips: Why does my form go completely blank?

Explains why no controls show on Microsoft Access forms sometimes, and how to address this issue.

allenbrowne.com