Access 2003 SP 2 opens queries brought in using transferdatabase?

C

ChristinaH

We have a database that our software will download and run a module to import
code fixes from that database into our software - sometimes the fixes are
queries.

In testing our last couple of updates, we have run into a problem with users
on Access 2003 SP 2. All of the queries being imported are opened before
they are brought into the new database. Since the tables do not exist in the
downloaded db, all of the table joins are broken and the field names in the
queries are replaced with Expr1, Expr2, etc.

This is a huge problem for us and I can't find anything to explain why this
is happening. Any ideas?
 

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

Top