senoritafish: (6yrsold)
[personal profile] senoritafish
Friday, I think I discovered a bug in Access. Since I’m new and stupid at it, I was trying to rename fields in the Database view, and since I wasn’t sure what a certain field I was importing contained, I kept trying to name it with a question mark. Every time I tried do this, the entire database crashed, and Access would come up with a
message that “Access has to close now, please send error data to Microsoft.” The database would close and reopen but if you tried to reopen that particular database it would crash again, and I would have to recreate the entire thing. Some computer guys were in the office upgrading machines and one of them was bored and tried to help me, but unfortunately, he didn’t know Access that well either. After they left I finally figured out what was going on – the question mark was causing it every time. Normally, you would get a message saying “This is a restricted character” (which you DID get if you tried to enter it in Design View). And, if had I known the program better, I would have known not to use a question mark.

Damn, Microsoft owes me now. Where’s my check?

Date: 2002-07-30 09:10 am (UTC)
From: [identity profile] metalmensch.livejournal.com
Any of the non-alpha numeric characters are usually banned from use in database programs. The reason being that they are used for commands. So basically, you named your field "do this".

Isn't it fun when the manual is thinner than the envelope which holds the CD?

Date: 2002-07-30 06:04 pm (UTC)
ext_341900: (Default)
From: [identity profile] senoritafish.livejournal.com
If you get a paper manual at all anymore; I'm sorry but I much prefer a book I can pore through when the computer is off, instead of an Acrobat file. Maybe it's a sign of my age.

I probably should have known not to use "?" , but any other time I put a restricted character in by accident, I got an error message telling me "Don't do that, silly user!". Should it have made the whole thing crash?

Yes, I'm probably one of those users who knows just enough to be dangerous. It's also fun when the director of our department declares we WILL change all of our software right when we have tons of deadlines

March 2016

S M T W T F S
  12345
6789101112
131415 16171819
20212223242526
2728293031  

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Feb. 27th, 2026 02:13 pm
Powered by Dreamwidth Studios