Can't add table to query

  • Thread starter Thread starter Leonard
  • Start date Start date
L

Leonard

I have been chewing on this problem (run time error 3101)
for a couple of weeks now, and it is driving me crazy.

Here is some additional info on the matter:

I can't add a table to my query without getting the 3101
error.

All I do is add the table to the query without referencing
the fields in the table on the form, and I get the error
message.

As long as I don't try to add a new table to my query
everything works fine in my form.

I have tried creating a new form and copying all items to
the new form but I still have the same problem.

I don't need to add a table to my query at the present
time but if I need to in the future, I will be F$%#@*.

I have also repaired and compacted many times.

Thanks for responding.

Leonard
 
Why a new Form? It sounds to me like the problem is more likely to be the
Query or general corruptions rather than the Form.

Note down details / SQL String of the Query, delete the existing Query and
then re-create the Query and see if it changes.

If the above doesn't work, it may be general corruptions. I had a weird
case where everything still worked fine but a Query took too long to process
(and I knew it shouldn't take that long). I created a new database and
imported all objects from the existing database (including the Query) and
everything worked perfectly including the Query running as fast as expected.
Thus, you can try the same technique creating a new database and importing
all objects from the existing database.
 
Thanks Van T. Dinh,

I tried that once before but didn't have much success.
There seemed to be alot of issues with compatiblilty when
I created the new DB, Tables, Queries, Forms etc. After I
imported everything over to the new DB I kept getting
errors when I tried to run the form. I tried to work
everything out but I guess I got lazy and gave up. I will
try it again per your suggestion.

Thanks again for responding.

Leonard
 
If you have errors after you import everything in the new database, more
often than not, one or more References are missing.

Note down the References in the existing database. Once you import
everything into the new database, open the VBE window and check the
References of the new database. Ad References as required and do a Compile
all to make sure that you don't have any Compile error in the new database.
 
Back
Top