Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'm trying to test a connection to a remote MS access database this is being held at a specific IP. How do I do that? What application do I use?

share|improve this question
    
does that ip address host a share or what? –  tony roth Apr 6 '11 at 17:20
    
...putting the MS database files in a network folder? –  jliendo Apr 6 '11 at 18:46
    
sure why not, not the best thing to do but if its all you got what are you going to do? His question needs clarification, as in is he really talking to a sql backend etc.. –  tony roth Apr 6 '11 at 19:00
    
Across what network? The Internet? Over what protocols? If it's not over SMB networking, you can forget it. Access/Jet/ACE files are only accessible through the Windows file system, either locally or over an SMB network. –  David W. Fenton Apr 6 '11 at 20:01
    
hopefully he updates the question otherwise he won't get an appropriate answer. –  tony roth Apr 6 '11 at 21:24

1 Answer 1

You can create a file with the .udl extension on Windows. Then double-click the file and you will get a wizard where you can enter any connection details. There should also be a Test button where you can test the connection.

share|improve this answer
    
That's just a way of working with ODBC data sources. This doesn't solve the problem as I read it, which seems to be about accessing a file across the Internet. –  David W. Fenton Apr 6 '11 at 20:01
    
@David W. Fenton: It is kind of hard to understand the exact problem by reading the question. The words test a connection and What application do I use led me to believe that he wanted to test if the database was available on the network without using Access. –  Nils Magne Lunde Apr 7 '11 at 5:20
    
The question title seems to involve more than that. –  David W. Fenton Apr 9 '11 at 22:00

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.