populate access across a network

[bultimatem]

I have an access database on my company's intranet. I would like to access that database from an excel spreadsheet from any computer on our network. In other words, I want to know if I can use the OpenDatabase method with an IP address or computer name for the server ie

OpenDatabase(\\someComputer\someFolder\myDatabase.mdb)

If I can't do that, does anyone know of a better way to do this besides forcing the user to map a network drive to someFolder and then using a path with the new drive name?

Thanks a lot!

Bryan


Bryan Marble
IEWS
BAE Systems