Hello! I want to move my backend tables Oracle and MySQL - Does anyone have a recommendation which platform works better regarding the conversion of the tables and linking to the Access front end? Thank you!
Novice
Windows 7 64bit 
Access 2010 64bit
Hello! I want to move my backend tables Oracle and MySQL - Does anyone have a recommendation which platform works better regarding the conversion of the tables and linking to the Access front end? Thank you!
VIP
Windows Vista Access 2010 32bit
once youve converted, you can change the links to the new backend and it will be seamless.
If you change the table names in the new backend, (this has happened to me) ,youd have to
relink each table ,1 by 1 to the backend. The frontend names remain the same so you dont loose queries or programming.
I also had code to swap out from Oracle/SQL BE to Access and back, depending on the need. (testing or other)
A button would relink them to Oracle, or relink to Access on demand.
Posting Permissions
Reply With Quote