Solved

Connecting ms access fron end to remote sql server

Posted on 2012-04-03
5
285 Views
Last Modified: 2012-04-24
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
Comment
Question by:kenabbott
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37801378
"Best way" is a vague term...
;-)

Have you tried:
External Data-->Import-->More-->ODBC
0
 

Author Comment

by:kenabbott
ID: 37801461
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
 
LVL 77

Expert Comment

by:peter57r
ID: 37801779
Please confirm that you can login to your SQL Server from your remote workstation. (or is your question about networking rather than applications?)
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 37801903
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
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 37804283
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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question