References issue

[WalterInOz]

A form in one of my databases became corrupted. I have recreated the form and it all works fine again but I thought it might be an idea to import all of this database into a newly created fresh one just in case some more minor corruption has sneaked into other forms. Well, did that and now I have a new problem that relates to something not being quite right with a reference. I get an error message: "Compile error, User-defined type not defined."

I understand this indicates a reference issue.

When I compare the references selected in the working DB and the non-working DB there is one difference: The working DB has the reference: "microsoft Windows Common Controls 6.0 (SP6)" selected.

This reference is not available in the entire library of the non-working one, so I cannot select it.

Anyone any ideas on what might be going on?

I'm using Access 2007 looking at both DBs on the same machine at the same time. Shouldn't the available references be identical?

 

[gemma-the-husky]

if you select it in the working DB - you should be able to see where the library is actually located, (at the bottom)

in the new DB, you should then be able to browse to the location, and add it manually.

missing references tend to sgow themselves by generating loads of spurious errors.

 

[CBrighton]

It's unclear whether the "non-working" database is the corrupt one or the one with an error message (as logically neither are "working").

If the non-working one is the one with the error message then follow Dave's advice above.

If it's that you have an extra reference in the non-corrupt database then try disabling it, if this doesn't work tell us what type it is which is undefined and we may be able to work out which reference is missing.

 

[WalterInOz]

OK. Tried the last suggestion first, i.e. disable the reference and see if the DB still works. Well, it doesn't, so the reference is essential. Unfortunately I cannot reselect the reference as it does not show up in the list anymore.
The issue is probably that working in Citrix and I can't get to any of the system folders. I'll call the administrator tomorrow and ask them to copy that reference to the indicated location. That should do it I hope.
Thanks guys for these suggestions. Very helpful.

 

[gemma-the-husky]

that's probably likely - on your own PC, when you install software the references get added into the registry somehow, which is how they show up in the access references list. (I think/expect)

on the (Citrix) TS, you won't have installed this software - so you either need to do so, or copy the library to a place where the citrix server can see it.

I am not sure what the file is, but you can probably download that from somewhere.

 

[WalterInOz]

Solved! I've downloaded a copy of the file (It's an .ocx file) a linked to it. I've put in a request to copy the file to the citrix server and will link to that one ones its done.

Thanks guys for your spot-on suggestions.