Question Linking Access tables to a remote SQL Server

[ken1921]

Hi

I have a local Access Program file and a SQL Server db on a remote computer. I want to link the SQL tables to the local Access file. What is the best way of doing this?

Many thanks

 

[plog]

Check out this microsoft link:

https://support.office.com/en-us/ar...data-a5a3b4eb-57b9-45a0-b732-77bc6089b84e#bm2

 

[Ranman256]

just use the linker...in menu; external data, more, SQL db,
select the odbc path
SAVE the password or every query will ask you for it. (done in odbc)
attach all tables needed.

 

[ken1921]

Many thanks.

I have followed instructions in the link and also ensured that port 1433 is open but I can't connect and getting attached error message.

All help gratefully received!