Just upgraded an existing dbase from Access 03 to 7 cannot link fo

[Guest]

Unable to link form fields together using a macro , vb or button option . The
relationship window allows a link to be established between tables etc but
the options on the dialog box are all grayed out and the relationship type
box remains blank. I have tried on a md version and the new files. The
existing links before conversion seen to be still ok.
The error messages state that it cannot find one of the fields or display a
Parameter box.

 

[Guest]

Access 07 will disable your code if the source file is not from a "trusted"
location. Click the Office button in the upper left corner, go to Access
Options. then to the Trust Center and add the file your db is located in to
the list of trusted locations. See if that solves your issue.

HTH

 

[Guest]

I have set up a trusted location and the database is in it before this
problem was noticed. The existing vb's and macros all work