Question Linking SQL Server Tables

[Eddie Mason]

I want to work on SQL Server tables located at my work place at home using Access. My question is; is it possible to link SQL Server tables on a server to my lap top computer using ‘Remote Desktop’ or will I need to install Access onto the server and if tables can be linked using Remote Desktop how do I link them? I am using Access 2010 and have Windows 7 professional installed on my lap top.

I hope someone can help kind regards,

Eddie

 

[GinaWhipp]

Hmmm, VPN to your Office, Citrix? Using Remote Desktop means you are really using your Office machine. And another consideration, most comapnies, if not all, will not allow access to their SQL Server via an outside source unless a secure line.

So, no you can't use the one on your laptop to connect to the SQL Server at your Office via Remote Desktop, not they way you are thinking.

 

[Eddie Mason]

Hi Gina,

Thanks for the advice, I was just being idle, I shall now have to go into work.

Kind regards,

Eddie

 

[GinaWhipp]

Heh, at least you now know the answer no more guessing!