run time error 2467

[Guest]

Since many of my databases use the same tables, I created one database
"Shared Files" and linked the tables to the other dabases. However now users
get the run time error 2467. If I import the tables vs. linking them, the
error seems to disappear. Any solutions?

 

[Douglas J Steele]

That doesn't really make sense. Error 2467 is "The expression you entered
refers to an object that is closed or doesn't exist." The only way you
should get that error is if you're trying to access the data through code.
Is that the case? What's the code you're using?

 

[Guest]

The only code that I can think of is

Me.Q_RQM_Pend_byRCA_subform1.Form.Requery

Where a user chooses his name from a linked table ins "Shared Files"
database. Subform 1 requreries based on the name chosen. User's records will
display based and a User - client assignment which is also stored in a linked
table from "Shared Files" database.

 

[Guest]

Can the code affect the user access to the tables in databases?

 

[Douglas J. Steele]

Is Q_RQM_Pend_byRCA_subform1 the name of the control that holds the subform?
That may or may not be the same as the name of the form that's being used as
a subform. If you created the subform by dragging the form onto the main
form, they should be the same, but if you selected Subform from the Toolbox
and created the container that way, it's probably named something like
Child0. Make sure you're referring to the container.

 

[Guest]

How can I find out if it's named Child(0)? In the properties window, Caption
is set to Q_RQM_Pend_byRCA_subform1. I did create the subform by clicking on
the toolbox.