Accessing local SQL server from Access Shortcut

[Peek]

Hi there,

I have two Access shortcuts on my desktop. One for live database, which is on the remote SQL server, and the other for the local SQL Server database, which is on the same machine.

Currently they both connect to live remote SQL Server database. I am trying to connect to local SQL Server database, which is on the same machine as the Microsoft Access is, from Access shortcut. Someone has showed me once by changing path in Access shortcut Properties, but can't remember. When I open Properties I only have 'Target' and 'Start In' fields. One for the actual .mdb Access file and the 'Start In' field for the folder where the file is.

The changes in registry has been already done. I think it just needs to be changed in Properties. Also, I was told that if I change for one it will change for the second shortcut too. That's why I am having a problem to switch everytime i want the change.

Thank you in advance

 

[HiTechCoach]

I have already replied on another forum.

A message to forum cross posters

 

[Peek]

Sorry about that, will do next time. I had quite good responses from the other post here: http://www.utteraccess.com/forum/Accessing-local-SQL-serve-t1953546.html&st=20

Thanks,

 

[HiTechCoach]

I now understand why you have not been responding at the other forum..

FYI: I spend most of my time at UA (16,097 posts to date) I am trying to spread out and post on other less active forums. Taht is why I saw all your post on the different sites.