By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,313 Members | 1,113 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,313 IT Pros & Developers. It's quick & easy.

Linking to MySQL from MS Access - Permissions

P: 3
This is my first project linking an MS Access (2003) front end to a MySQL back end. I've created and populated several tables in the MySQL database. I can read/write all of them except one from my Access front end. On that one, I get a 1064 error whenever I try to change a value. In the simplest case, I'm just changing a 0 to a 3 directly in the table. (This field is a float, which Access sees as a single, but I get the same result when I try to update any field in this table.)
As far as I can make out, this is a permissions issue.
If this is not enough information, please let me know what else I can tell you.

TIA!
Jul 31 '07 #1
Share this Question
Share on Google+
1 Reply


10K+
P: 13,264
This is my first project linking an MS Access (2003) front end to a MySQL back end. I've created and populated several tables in the MySQL database. I can read/write all of them except one from my Access front end. On that one, I get a 1064 error whenever I try to change a value. In the simplest case, I'm just changing a 0 to a 3 directly in the table. (This field is a float, which Access sees as a single, but I get the same result when I try to update any field in this table.)
As far as I can make out, this is a permissions issue.
If this is not enough information, please let me know what else I can tell you.

TIA!
I've copied the question to the access forum.
Link
Jul 31 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.