Microsoft ACCESS pb: "INSERT INTO table"

[Anon]

Here what I do to modify an MAccess Database with ODBC where I have a table well formated:

Code --->

$connect = odbc_connect("emos_web.mdb","","");

$query = "INSERT INTO table VALUES ('1','value 1')";

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

Result --->

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecDirect

PLEASE HELP ME, the connection to database is OK for all SELECT things but can't alter the ddb!

[Anon]

String url = "jdbc:odbc:Ashish";
String query = "insert into business values (?, ?)";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection x = DriverManager.getConnection(url);

PreparedStatement y = x.prepareStatement(query);

y.setString(1, "your textfield name");
y.setString(2, "your textfield name");

In Access

Connection x = DriverManager.getConnection(url) //"This is right"

Connection x = DriverManager.getConnection(url,"","") //"This is wrong" This is when you use SQL as Database

you can contact me at
[e-mail]

[Anon]

One question though, if u're not using DSN for ODBC_Connect('THE DSN NAME', 'root', '');

then how is it u connect with the database using the Codes you gave which is the DriverManager.getConnection(url)???

Could you pls help explain with a lil' depth on the steps involved to make connections with access database using your method.

thanks

[jhonrputra]

Hi...

Please check this:
1. Have you make a DSN for your MS. access database?
2. in statement odbc_connect(), please use your DSN to connect, example:
odbc_connect('mymdbdsn','','');
3. After that, verify if you have been connected or not.
4. Check the structure of your mdb, focus on the field that you assigned it as "Key". Please note this, of course you cannot insert two or more records that have the same value in "key" field. So, if you want to check your code more than one time, please change your value, example:
try 1:"INSERT INTO table VALUES ('1','value 1')";

try 2:"INSERT INTO table VALUES ('2','value 1')";

assume that first field is the key.

or you can make a form first, then execute your code to insert record with your form.

3. That's for now. Good Luck!!!

[Anon]

testpost

[Anon]

trttr

[Anon]

Maybe, the database is readonly.