Member Avatar for j1979c

Has anyone noticed that...if you create a ms access database with "Password" as one of the table's column name....

You can't make a data insertion through sql statements via oledb (no rows are affected)?

like : insert into employees(password) values('asd32f1asdf')

wasted me 1 1/2 hours trying to debug the thing in visual studio...

when I named the column to "Pwd" instead.... everything works.... :lol:

weird.....:confused:

it's just the same like when you create a new folder ... naming it "con" won't work... lol

  • 4 Contributors
  • 4 Replies
  • 96 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by j1979c

Recommended Answers

All 4 Replies

Member Avatar for ManicCW

It's not just "password", there are some more words that you cannot use. But I cant find full list on microsot. :(

Member Avatar for fireworks-style

Hi,

I have that list bookmarked somewhere, I think on my work laptop. I'll look tomorrow, might be useful for other forum readers too. :)

Member Avatar for Paladine

Here is a link..

NOTE: Access is not inclusive of the JET engine. So for a full comprehensive list you have to consider the JET engine keywords

Member Avatar for j1979c

I see..... so the "password" is a jet reserved word. No wonder I don't get errors during creation time but do get them when trying to access it through ole db via the jet engine. :p

Thanks Paladine for sharing the list. :mrgreen:

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.