Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 293
  • Last Modified:

Connecting ms access fron end to remote sql server

Hi

I need to connect an access front end to a sql server back end on a remote server - what is the best way of achieving this?

Ken
0
kenabbott
Asked:
kenabbott
1 Solution
 
Jeffrey CoachmanMIS LiasonCommented:
"Best way" is a vague term...
;-)

Have you tried:
External Data-->Import-->More-->ODBC
0
 
kenabbottAuthor Commented:
Good point although the answer also seems a little vague!  I don't have ODBC under the 'More' menu although there is an ODBC icon next to 'More' (I have Access 2010).  

So once in ODBC... what next?
0
 
peter57rCommented:
Please confirm that you can login to your SQL Server from your remote workstation. (or is your question about networking rather than applications?)
0
 
Jeffrey CoachmanMIS LiasonCommented:
Here is what my screen looks like:
screen

...as far as "what next?"..

Simply follow the rest of the Wizard steps...

Select "Link to the data source..."
...then fill in all of the appropriate Data Source and Server info...

These are the basic steps that always work for me, your environment may be different.

Pete can probably help more with the connection stuff...
0
 
Anthony PerkinsCommented:
what is the best way of achieving this?
The best way is using code.  But I suspect this is not what you want to hear.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now