-
Jan 19th, 2010, 03:50 AM
#1
Thread Starter
Don't Panic!
[RESOLVED] [Access 2003] Query that doesnt run right
Hi
In Access 2003 I have a query. Its been running fine until last month, where it refuses to run (executed from Excel).
I have found out that its erroring stating that there are records already existing with the primary key. Fair enough. Except the wuery has been written to exclude those that have the primary key.
So it looks like Access is ignoring the filter condition and running the lot or is not retrieving data correctly.
Has anyone else had this recently (perhaps an MS Office update to break 2003 and request 2007 upgrade??) ?
I am going to look further into it, but the second query erases the data in question, so tonight I shall have another look.
---
Could it be that there are duplicate records in the main table, that dont exist in the second table, but do after it adds the first record?
Feeling like a fly on the inside of a closed window (Thunk!)
If I post a lot, it is because I am bored at work! ;D Or stuck...
* Anything I post can be only my opinion. Advice etc is up to you to persue...
-
Jan 19th, 2010, 04:39 AM
#2
Thread Starter
Don't Panic!
Re: [Access 2003] Query that doesnt run right
Dont worry about it, its duplicates adding from the main list - fixed now
Feeling like a fly on the inside of a closed window (Thunk!)
If I post a lot, it is because I am bored at work! ;D Or stuck...
* Anything I post can be only my opinion. Advice etc is up to you to persue...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|