Sequence of query order changes from 97 to 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a set of queries named '11 make table', '11a update table', '11b
update table' etc in Access 97. When I convert this database to Access 2000
the sequence of queries is being changed. The order of the queries in Access
2000 is '11a update table', '11b update table' , '11 make table'. This will
lead to a run time error as we are trying to update a table even before it is
being created.

Pl., can anyone provide me a solution to this problem as I have a lot of
queries (approx 100) and it is difficult to change the order to all.

Thanks,
Venkat
 
Do you use code to run the queries or do you expect a user to sequentially
run them from the database window? I recommend not allowing users to see the
database window. You could add and display a description for the queries and
sort by the description.
 
Thanx for ur reply.

The problem is we cannot give the description for all the 100 queries and
that too across many (50) database as this transition to Access 97 across the
department. This there any other solution as the user will be executing these
queries sequentially.
 
I have tried the option of using the description and then sorting it. But
this still not work and order us still the same.
 
I believe in taking the time to do this correctly. Use code to allow your
user to run the queries. Don't show users your database window.
 
Back
Top