If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Weirdest Thing Yet in Access 97
Alright, I know everyone's going to think I'm crazy but I'm not making this
up. I've been working on an Access 97 application that has been acting up lately. Strange unpredictable behavior. In trying to figure out where the problem was, I was browsing through my list of tables and came across a table I NEVER created called "Paste Errors". I opened it up and found only one field, a text field called Field0. In that field was one record with the following entry: "master_of_pain6215 " I tried deleting this table and the strange behavior persists. This application hasn't been put "online" yet and no one could have inserted this table. I did a google search using the above entry and got no relevant hits so it doesn't seem as though others have reported this. Is there some sort of virus that can enter Access 97? Anyone know how to purge this? Any thoughts greatly appreciated. John |
#2
|
|||
|
|||
I think you're going crazy ;-)
"Paste Errors" is a standard table created by Access when you import stuff. It lists items which couldn't be imported, for whatever reason. The table will then sit there until you delete it, so it might be leftover from an import of 5yrs ago. 10yrs ago? If I said 20yrs ago you might conclude I am crazy. Chris "John S. Ford, MD" wrote in message Alright, I know everyone's going to think I'm crazy but I'm not making this up. I've been working on an Access 97 application that has been acting up lately. Strange unpredictable behavior. In trying to figure out where the problem was, I was browsing through my list of tables and came across a table I NEVER created called "Paste Errors". I opened it up and found only one field, a text field called Field0. In that field was one record with the following entry: "master_of_pain6215 " I tried deleting this table and the strange behavior persists. This application hasn't been put "online" yet and no one could have inserted this table. I did a google search using the above entry and got no relevant hits so it doesn't seem as though others have reported this. Is there some sort of virus that can enter Access 97? Anyone know how to purge this? Any thoughts greatly appreciated. John |
#3
|
|||
|
|||
If you import/paste data into an Access table, and there is any problem with
the insert (e.g. required field missing), Access creates a table called "Import Errors" or "Paste Errors" so you can review the records that were not correctly imported. This is normal (and very useful) behavior. If you don't care about which records did not import correctly, you can safely delete the table. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "John S. Ford, MD" wrote in message ... Alright, I know everyone's going to think I'm crazy but I'm not making this up. I've been working on an Access 97 application that has been acting up lately. Strange unpredictable behavior. In trying to figure out where the problem was, I was browsing through my list of tables and came across a table I NEVER created called "Paste Errors". I opened it up and found only one field, a text field called Field0. In that field was one record with the following entry: "master_of_pain6215 " I tried deleting this table and the strange behavior persists. This application hasn't been put "online" yet and no one could have inserted this table. I did a google search using the above entry and got no relevant hits so it doesn't seem as though others have reported this. Is there some sort of virus that can enter Access 97? Anyone know how to purge this? Any thoughts greatly appreciated. |
#4
|
|||
|
|||
He's a Doctor too. I s'pose it's just as well he checked before removing
something :-)) |
#5
|
|||
|
|||
I don't have to check . I'm not a surgeon.
John He's a Doctor too. I s'pose it's just as well he checked before removing something :-)) |
#6
|
|||
|
|||
This is a standard thing Access does. At some past point, you or someone
tried to paste data into a table. All the data from the source was pasted in except "master_of_pain6215 ". Access alerts you to this when it happens. If you were the one pasting, perhaps you forgot this happened. If someone else pasted, they forgot to tell you. BTW, it will happen manually or programatically. -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com "John S. Ford, MD" wrote in message ... Alright, I know everyone's going to think I'm crazy but I'm not making this up. I've been working on an Access 97 application that has been acting up lately. Strange unpredictable behavior. In trying to figure out where the problem was, I was browsing through my list of tables and came across a table I NEVER created called "Paste Errors". I opened it up and found only one field, a text field called Field0. In that field was one record with the following entry: "master_of_pain6215 " I tried deleting this table and the strange behavior persists. This application hasn't been put "online" yet and no one could have inserted this table. I did a google search using the above entry and got no relevant hits so it doesn't seem as though others have reported this. Is there some sort of virus that can enter Access 97? Anyone know how to purge this? Any thoughts greatly appreciated. John |
#7
|
|||
|
|||
Hi Dr Ford,
Is Master of Pain 6215 maybe a subject you took at uni, like Anatomy 101? "John S. Ford, MD" wrote in message ... Alright, I know everyone's going to think I'm crazy but I'm not making this up. I've been working on an Access 97 application that has been acting up lately. Strange unpredictable behavior. In trying to figure out where the problem was, I was browsing through my list of tables and came across a table I NEVER created called "Paste Errors". I opened it up and found only one field, a text field called Field0. In that field was one record with the following entry: "master_of_pain6215 " I tried deleting this table and the strange behavior persists. This application hasn't been put "online" yet and no one could have inserted this table. I did a google search using the above entry and got no relevant hits so it doesn't seem as though others have reported this. Is there some sort of virus that can enter Access 97? Anyone know how to purge this? Any thoughts greatly appreciated. John |
#8
|
|||
|
|||
He's a Doctor too. I s'pose it's just as well he checked before removing
something :-)) I don't have to check . I'm not a surgeon. GRIN My confidence is now restored. I s'pose it's inappropriate to relate about the American Doctor who "attended me" in McMurdo Antarctica. We were having quite a discussion, and he gesticulated so much that he accidentally speared me with the syringe he was holding. There seems to be no residual harm done, unless insanity is a virus? THIS IS TRUE (albeit 1976) Chris :-) |
#9
|
|||
|
|||
GPO wrote:
Hi Dr Ford, Is Master of Pain 6215 maybe a subject you took at uni, like Anatomy 101? Isn't it an Ozzy Osborne album? g LeAnne |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conversion Problems | Katherine R | New Users | 11 | December 19th, 2004 12:38 AM |
Access XP Compared to Access 2003 | Mardene Leahu | New Users | 1 | October 1st, 2004 05:11 AM |
Adding staff photographs to my database | KK | New Users | 2 | September 3rd, 2004 07:41 AM |
Data from Excel to Access | Database Design | 2 | August 20th, 2004 12:53 PM | |
Need Entry Point 18 Help On Access Executable File | Jeff Conrad | General Discussion | 26 | July 14th, 2004 06:00 AM |