Hello....looking for some help with how to do this.
I have a local Access database and want to take one of my tables and put it on a SQL server in AWS and then link to it from my Access database. IT has setup an instance for me to use, but as of now I only have the user/pass.
Can someone tell me what I need from my IT dept. in terms of information, then how to do what I need to do. Ultimately the goal is to use my local Access database as a front-end to update data on the remote linked table in SQL. I'm a novice Access user, and any remedial help is greatly appreciated.
I have a local Access database and want to take one of my tables and put it on a SQL server in AWS and then link to it from my Access database. IT has setup an instance for me to use, but as of now I only have the user/pass.
Can someone tell me what I need from my IT dept. in terms of information, then how to do what I need to do. Ultimately the goal is to use my local Access database as a front-end to update data on the remote linked table in SQL. I'm a novice Access user, and any remedial help is greatly appreciated.