References not saving

[dcnick]

I have a replicated database in Access 2003 w/ SP2. A coworker in another location controls the master database. We have the following references selected in VBA (listed in order):

VBA, Microsoft Access 11.0 Object Library, OLE Automation, Microsoft DAO 3.6 Object Library, Microsoft ADO 2.8 Library, Microsoft Excel 11.0 Object Library, Microsoft Graph 11.0 Object Library

Whenever I close out the database and reopen it, the last 2 references (Excel and Graph) are not listed, and I get an error when trying to run a module unless I go back in to tools and recheck these 2 items (which are lost again when I close the database). When my coworker opens the database I send her (she also has Access 2003 w/ SP2), she has to initially recheck the Excel and Graph references, but they are not lost when she closes out the database and reopens it.

Any ideas of what is going on and how this can be fixed? Several users enter data in the database, and I don't want them having to go in and recheck these references. Any help is appreciated.

Thanks

 

[Robert88]

Hi dcnick

Have you compiled the VBA?

Robert88

 

[dcnick]

Yes, I've compiled after rechecking the references.

 

[Robert88]

Hi dcnick,

Your office suite, has it been loaded correctly? Or has something gone astray with it?

I am wondering the loaction of the *.dll files that these references refer to have been moved or are in another location? Usually located in C:\Windows\System32\*.dll or C:\Program Files\Common Files\..... [various folders].

I am wondering if any of these have been tampered with, moved, deleted, etc.....

Maybe if you run from a command prompt "sfc /scannow", Microsoft's system file checker. You will need the operating system disk. A couple of references for this issue are;

http://support.microsoft.com/?kbid=310747

&

http://www.updatexp.com/scannow-sfc.html

Not sure if it will help, can't hurt.

Robert88

 

[dcnick]

Ok. We've discovered an interesting twist to this today. These problems only arise for users that do not have admin rights to the computer. If a user has admin rights, the database works just fine. The 2 errors we get for those without user rights:

1. When we start the database, it says we have a missing link to fxsocm.dll file. The file is located in c:\windows\system32\setup folder, which only computer admins can access. I tried to copy the file to c:\windows\system32 folder, and I get “access denied.”

2. The Microsoft Excel and Graph Type library references are now there, but it claims I’m missing the FaxControl 1.0 Type Library. I click “browse” and relink it and compile it, but it’s missing again after I close out the database and reopen.

I've tried researching on the web regarding user privileges but have come up with nothing. We don't assign passwords or user permissions to the database.

 

[Robert88]

Hi dcnick,

Sounds like something has gone astray, what are the chances of re-loading this software? Or uninstall and re-install?

Robert88

 

[dcnick]

ok...FINALLY resolved.

The database was looking for the fxsocm.dll file (inlcuded in Windows SP2). The file was located in c:\windows\system32\setup folder. Only personnel with computer admin rights are able to see that folder, which explains why there is a missing link when users w/o computer admin priveleges tried to use the database.

We moved the .dll file to the c:\windows\system32 folder (1 level up), and now the database works like a champ.

Thanks for all the responses...they definitely pointed me in the right direction for troubleshooting.