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
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