[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 289
  • 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

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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