can't access references on menu

[arkres]

I have distributed an Access 2K database to individual users. It's running well on all but two computers. It seems to be a reference problem, but "references" on the tools menu in an open module is disabled. Has anyone ever come across this problem before? If not, I'll explain in more detail. Thanks much

 

[maxmangion]

are you refering to an mdb version or an mde version ?

 

[arkres]

Hi,

I am referring to an mdb version....any clues?

 

[The_Doc_Man]

The question is whether the persons using the DB have admin rights on their assigned machines. If not, then you will need a site administrator to log in so you can correct the references. (If you can't update the registry, you can't update the references. If you ain't an administrator, you can't update the registry.) This occurs at any site where the rights applied to a workstation are tightly controlled by the security department.

It could ALSO be a permissions issue if the user account under which you are running does not have Modify rights on modules.

 

[arkres]

I think you're right. Company downsized to almost zero IT personnel....no one knows what took place in the past. It's like a big mystery! Thanks for the input. I'll do some investigating on Monday.

 

[Matt Greatorex]

I came in this morning to find I had the same problem as described above. The first time a section of code hits a DoCmd.RunSQL command, I receive a 'Cannot find project or library' message. When I tried to add the library back in, I found that the 'References' option, under the 'Tools' menu was disabled. In my case, both appear to have been caused by my PC being replaced, while I wasn't around.

I can get my permissions returned and add back the functionality I needed, but it got me thinking:

I'm working on an application to be used by many people, in various locations within the company. Am I going to need to repeat this process on every PC that needs to access it? If so, is there any way around this i.e. a way to permananetly 'attach' the add-ins to the application.

If not, was it just a coincidence that I lost the add-ins at around the same time the PC was replaced? What else might have caused it?

At the risk of sounding overly vague, eveything was working fine on Friday. I left for the weekend, arrived this morning and I've got the problem.

 

[Matt Greatorex]

Fixed

Okay, in case this is of use to anyone else, the problem was caused by the following:

When I left work on Friday, I had the object libraries for MS Word, Excel and Access installed at v10.

When the techies here replaced the PC, they overwrote the MS Access library with v9. Since reinstalling the v10 library for Access wasn't an option (for reasons too dull to go into here), I tried removing the Word and Excel libraries and re-installing them at v9.

This works fine and I get no more errors.

 

[RuralGuy]

Thanks for taking the time to post your resolution Matt. I'm sure others will benefit. Aren't those little elves that work when you are not there wonderful?