Linking field in MySql table to Access database

[occyink]

I run a website selling cartridges. My stock on the website is in a MySql database. My accounts package and invoicing software runs on an Access database. In my website databse there is a table called products, on my accounts Access database there is a table called items. I am trying to link certain fields in MySql database with certain fields in Access database. The reason for this is so when I update the price in the accounts database (access) it automatically updates the price for the website database (MySql)

I have managed to link the tables but it does not give me an option to pick certain fields from the linked table. I am VERY new at this database programming so please bear with me but I really need some help as it is driving me mad.

[Atli]

Hi. Welcome to The Scripts.

Could you show us what you have done so far?
My Access skills are a little rusty (to say the least), so it will help to see what you are doing.

[occyink]

Well, I have opened my accounts package which has a table called items. This holds all the fields like product name, price, cost, mark-up etc. In MySql database there is a table called products. In this there are fields called product code, price, cost etc. The fields dont line up as the MySql database has more fields than the access one and the names are different. I cannot re-name any field as this would cause the program to stop working.

I created a linked table in access but it brings over all fields, thus making it read only. When I link to the MySql database table, it does not prompt me for which field I need. Am I doing something wrong? Thanks for your offer to help.