hi guyzz, i wanted to have two connection using access and mysql in my proj. my access was my main db connection and what ever data in my access will store directly in mysql db when their is internet connection...
I declared 2 fuction connection but my problem is the switching of the recordset. "OpenRS" and "OpenRS2"
i declared "OpenRS" in every table in Access but my second connection is "OpenRS2" for my mysql.. how can i use the OpenRS2 in saving that will no change in every code in every forms.
any help or comment will appreciated........... thx in advance..