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?
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.