I'm sure many people know that this happens .... but does anyone know why you're not allowed to have a column named "password" in any tables? You're allowed to create it in Access, but it always creates errors when using ADO.net to insert records, update etc.
Anyone know why that happens?
Strange tendency in MS Access?
Moderator: General Moderators
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
Re: Strange tendency in MS Access?
Like hawley said, Password is reserved. Many database applications and management systems reserve words for the system that cannot be used as field names. MySQL has a table of reserved words on their website, so I would imagine that MSDN would have something similar.erupt wrote:I'm sure many people know that this happens .... but does anyone know why you're not allowed to have a column named "password" in any tables? You're allowed to create it in Access, but it always creates errors when using ADO.net to insert records, update etc.
Anyone know why that happens?
Hawley, does Access accept backticks in queries? I thought Access uses brackets for field names ([tablename].[fieldname]). Just a thought, if backticks don't work try brackets.
Re: Strange tendency in MS Access?
Ha Ha, I have no idea that's why I said `try` (No pun intended on the hash markes used in try)Everah wrote: Hawley, does Access accept backticks in queries? I thought Access uses brackets for field names ([tablename].[fieldname]). Just a thought, if backticks don't work try brackets.
It's prob. been 6 years since I've even opened up Access
Don't create the field with backticks.
Use it in your query.
Although, like everah said, msaccess uses brackets.. so try that.
Use it in your query.
Although, like everah said, msaccess uses brackets.. so try that.
Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.