INSERT MS Access

[Anon]

• ODBC well configured
• SELECT works perfectly
• But cannot INSERT or DELETE or any kind of alter the MS Access Database.

Anybody have the good syntaxe?
Thanks for you help. Paul

[crowezr]

You will probably want to check the permissions that the group "everyone" has on your database file. I had similar problems, so I just changed the permissions in Windows to include write for everyone. I think by default, everyone is only given access to read the database. Hope this helps!

[Anon]

Actually my "Everyone" had full power !!! 🙂

But I found the trick... Not so much actually.

Under MS Access, when you put an "auto increment" field and your query value is empty --> then error like:

"SQL error: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression., SQL state 22005 in SQLExecDirect in C:\Inetpub\wwwroot...php3"

My syntaxe is this one so:

$connect = odbc_connect("mydb","","");

$query = "insert into authentification values ('4','company4','login4','paswd4','name4')";

$result = odbc_exec($connect, $query);

odbc_close($connect);

-->So cannot put $query = "insert into authentification values ('','company5','login5','paswd5','name5')";
for the next query...

Any idea... Thnks.
Paul

[crowezr]

I had a similar problem using Access. Instead of just telling SQL to insert the values into the table, you have to specify which fields you want entered. If you don't include the auto_increment field in the list, it will just add one without any problems.

$connect = odbc_connect("mydb","","");

$query = "insert into authentification(company_name,login,password,name) values ('company4','login4','paswd4','name4')";

$result = odbc_exec($connect, $query);

odbc_close($connect);

[Anon]

CA MARCHE !!!!
IT WORKS !!!!
Thanks a lot that's a pleasure to work with you 😉
polo.