VALENC1ANO Posted February 5, 2008 Posted February 5, 2008 hi, i have conected access with my oscommerce in localhost. I have in access all tables from oscommerce. The problem is if i need to change the stock in the products table, for example. If i try to change it, access show me an error and not allow to change the stock in the table products on oscomerce. I have seen in other forum than the solution is to create a timestamp field. Is possible that i have created wrong the timestamp field with mysql or is possible the solution can be other. please, sombody could help me. very thanks from Spain
masat Posted February 6, 2008 Posted February 6, 2008 I'm probably not going to be of much help here but it sounds like you know access pretty well. I have done the same type setup before on at least three other occasions and all three were nothing but trouble. If I recall correctly the trouble is mysql and access read and build timestamps differently but that is fixable by changeing the field in mysql to something other than a timestamp (I think). The timestamp field in mysql updates automatically on each record change so occurs the error with access. The other issue I had was constant and often untimely dropped connections in the odbc driver. Never have figured out why that happens. Good Luck on this one. You might try an access forum too. How do you know when you know what you want to do for the rest of your life?
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.