Search results

  1. J

    Linked Tables from access to MySql

    Yes the database only has tables only (no objects ect). as with permissions i dont fully understand (havnt done much work with access). It does have a password to open the actual file tho. The customers table id used to be auto number however now that it is linked it is a text field and cannot...
  2. J

    Linked Tables from access to MySql

    Thats right, Sorry about that. So its giving me the error message "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." Any idea's? Justin
  3. J

    Linked Tables from access to MySql

    Okay, Its for a large television repair agent. They are using the program to raise repair jobs ect. This program saves all detail to access database. Im making a script on there website so customers can login and view there repair status. The website has a MySql database. So its not...
  4. J

    Linked Tables from access to MySql

    Understang Mysql manager LOL... The SQL string is within the program which i have no access to. I have simply exported the customer table to mysql then created a link to mysql database. I created a timestamp and auto_increment as the mysql site suggested with no differance. The program...
  5. J

    Linked Tables from access to MySql

    Thanks for the fast reply. Im intergrating this website into a pre-made program (have no access to un-compiled files) so i cant give you the sql the program uses. Im using the latest version ODBC 5.1 as i downloaded them last week. Its linked to PhpMyAdmin. and it accurs when i add a new...
  6. J

    Linked Tables from access to MySql

    I am working on a project that uses a VB program and connects to a access database to store customer records ect. Im adapting this to a website so customers can view there repair status. how ever in order to do this i have to link tables from the access database to the MySql databse required...
Back
Top Bottom