Changing queries by code

  • Thread starter Thread starter casey
  • Start date Start date
C

casey

This is driving me mad!
I have a vb routine (used many times with different dbs) that uses the
querydef object to delete existing queries and copy new ones from
another mdb (2000). System is running on XP.

5 out of the 6 copied queries are fine. The problem child always
reverts to the original format where the parameters are used
incorrectly. Manually I can import the new query to a new name, delete
the original and then rename the imported one- not an option for remote
users.

This only happens in two of the 6 databases being updated

Whats the problem , some left over replication stuff ???

Casey
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tables in Access Queries overwritten??? :( 2
Queries losing fieldnames when importing from external mdb 2
Query field size quandry 2
Recordset from Parameter Query 2
Query keeps looking for Query1 field 3
How stop access query from replacing our SQL code 1
replicating action queries in sql server 1
Append query locks application 2

Back
Top