Use database from share

[jonesnet]

Hi

I'm a sysadmin, and not very good at programmeing, so hope you can help

I have a webserver, which is going to read a database (DB) from a share on another server.

I have this code to identify the DB:
<OdbcData Name='data2005'>
<FileName>\\server\share\db.mdb</FileName>
<DataSource>Select * from 2003
</DataSource>
</OdbcData>

But it doesn't find the DB.
It returns a &quot;No data in grid&quot;

If I put the DB on the c: drive, I can access the DB by writing c:\db.mdb instead of \\server\share\db.mdb
The share is on a Windows 2000 server and the permissions is full control to everyone on the DB and on the share.

Is it an error in the code, or is XML not able to understand the sharename?

/J