One of my coworkers cannot run an append query, because he gets this error message. I am able to run the same append query, if I use different criteria, so it seems there is nothing wrong with the query itself. Could some of the data be corrupted somehow? It seems like there is something wrong with the set of records he is using, but I could be mistaken. Please help!!!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
"No Current Record" error message in append query
- Thread starter jobb
- Start date
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 73,434
- Office Version
- 365
- Platform
- Windows
Re: "No Current Record" error message in append q
If you try to run the EXACT same query with the EXACT same criteria as him, what happens?
If you think the database may be corrupt, go to Tools, Database Utilities and select "Compact and Repair Database".
If none of that works, please post the query (if you go to SQL view in the query design mode, you can copy the SQL representation of the query). Also, explain what the tables involved look like and what is supposed to happen (giving examples may also help).
If you try to run the EXACT same query with the EXACT same criteria as him, what happens?
If you think the database may be corrupt, go to Tools, Database Utilities and select "Compact and Repair Database".
If none of that works, please post the query (if you go to SQL view in the query design mode, you can copy the SQL representation of the query). Also, explain what the tables involved look like and what is supposed to happen (giving examples may also help).
Upvote
0
Re: "No Current Record" error message in append q
never mind the query, my table is having odd records go corrupt when certain values are input into the field [Branch #].
For example, if I put any other number in a certain record, I am able to add or edit the record. However, if I put the number "1703" as the branch#, and try to save the record, I get the error "No Current Record". I can't figure out why it wouldn't allow a particular number to be used.
The only possibility I could come up with is that my table has an odd index. It has a multiple field index with no dupes allowed, where branch # is the first field listed in the index. However, in the case above, the records I was trying to add and edit with the branch # 1703 wouldn't violate this index.
Any Ideas?
It seems like these records are just becoming corrupted, but I have no idea why, or how to prevent it. Would a "repair database" be worth the effort of trying to kick everyone out of the database? (which can be quite an undertaking)
never mind the query, my table is having odd records go corrupt when certain values are input into the field [Branch #].
For example, if I put any other number in a certain record, I am able to add or edit the record. However, if I put the number "1703" as the branch#, and try to save the record, I get the error "No Current Record". I can't figure out why it wouldn't allow a particular number to be used.
The only possibility I could come up with is that my table has an odd index. It has a multiple field index with no dupes allowed, where branch # is the first field listed in the index. However, in the case above, the records I was trying to add and edit with the branch # 1703 wouldn't violate this index.
Any Ideas?
It seems like these records are just becoming corrupted, but I have no idea why, or how to prevent it. Would a "repair database" be worth the effort of trying to kick everyone out of the database? (which can be quite an undertaking)
Upvote
0
Similar threads
- Question
