Solved Insert data in phpmyadmin MYSL from MS Access

nector

Member
Local time
Today, 10:41
Joined
Jan 21, 2020
Messages
462
I'm trying to insert data into cPanel MySQL with MS Access linked tables, I'm failing what should I do , I simply exported all the access tables to cPanel using ODBC for MYSL all went well and the speed is extremely good, even combo boxes with a lot of data they are working okay and fast.

Any idea how to do it with linked tables?
 
What have you tried? If Access is linked to cPanel and data shows in Access, then normal data entry or SQL should work.
 
I think I need also timestamp here
 
Okay here is the message I'm getting when trying to insert data in Phpmyadmin cPanel database from MS Access

LINKED TABLES FAILING.png
 
its looks like its the issue of primary key not assigned as auto increamental, let me invegiate on this one
 

Users who are viewing this thread

Back
Top Bottom