cannot open table?

[damcloodt]

Hello,

I want to create a new table with the use of a query (using an already existing table), however, there is a problem. I created the query and made a new table query, however, i can not run the query because in that case i get the following message: can not open table because someone else is already using it (?????). what can i do to create this new table. I want to create 3 new tables, for 3 different years, it first worked for the first two years, but then with the third one i get the message above?? There is nothing wrong with the column of year3, so how to resolve this problem?

Thanks a lot for all your help!

Kind regards, Daniëlle.

 

[apr pillai]

Check whether you are using the output Table name same as of the Make-Table Query. If so give the output table name something different.

 

[damcloodt]

I already used a different name, that's the weird thing!