Has anyone had any experience in linking a field from a MySQL database with differently named field in an Access database?
I can link the two databases, and certain tables, but I would like to link say the user_info field in the MySQL database to the user_personal_info field in the Access dbase.
The situation is that I have an existing website and an existing accounting system and I want to keep them linked via the internet. I want the website to update the accounting/POS system and vice versa.
Any help is greatly appreciated!
Thanks,
Devin Pittman
I can link the two databases, and certain tables, but I would like to link say the user_info field in the MySQL database to the user_personal_info field in the Access dbase.
The situation is that I have an existing website and an existing accounting system and I want to keep them linked via the internet. I want the website to update the accounting/POS system and vice versa.
Any help is greatly appreciated!
Thanks,
Devin Pittman