Access linked table to remote SQL (1 Viewer)

mahjohn

New member
Local time
Today, 07:17
Joined
Jan 30, 2019
Messages
7
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.
 

Ranman256

Well-known member
Local time
Today, 10:17
Joined
Apr 9, 2015
Messages
4,339
the I.T. dept puts the table into SQL db.
you then , in Access , link to it using ODBC, in EXTERNAL DATA tab:

Open Access app
Click external sources, ODBC, select your SQL driver
LINK to table via odbc (or build a link here)
select the table

it now becomes a table inside access.
 

mahjohn

New member
Local time
Today, 07:17
Joined
Jan 30, 2019
Messages
7
Cheer, got that sorted, now to work on the efficiency.
 

Users who are viewing this thread

Top Bottom