By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,441 Members | 996 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,441 IT Pros & Developers. It's quick & easy.

Trouble with query importation

P: 2
Hi, I am working with 3 acces 2000 database. I have make 20 query to extract informations on these database. The 3 database have the same structure and datatype bot not the same records. When I import my queries to one database to another some of them stop working correctly. For example, if I use the exported query a have approx 8000 records and when I remake the same query (exactly the same) I got a result of 9000 record. Does somebody know why and how I can transfers my queries without this kind of problem. (I use the get external data method)

I use acces 2003 on a XP pro OS. All 3 database are use by the same program.


PS: Why sometime I just have to erase a formula, save the query and put back the formula and re save it to make a query work. Office is a bug itself or I do something wrong ?
Mar 14 '07 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 10K+
P: 14,534
Not sure what is going on. Can you post a SQL example of one of the queries you are talking about?

Mar 17 '07 #2

P: 2
I do not work in SQL windows. The simple function "between" 10% of the time don't work when importated.
Mar 18 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.