I'm busy with a school project and I want to know
"if and how it is possible to connect to a MS Access file on another PC
using OLEDB"

I have looked in many places on the internet, but they all came up with files on the same machine.

Thanx in advance

Dennis

It is not recommended using an Access database on a remote machine, because
performance is awful. Access isn't a database server - it's just a file
based database, and you end up pulling the whole file across the network to
run queries.

If you're using anonymous access, change the anonymous account in the IIS
MMC Snapin to a domain account. Give that domain account permissions to the
share on the remote machine. In your connection string use Data
Source=\\server\share\myDatabase.mdb;

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Dennis van Herk" <d.van.herk@w...>
Subject: [asp_databases] connection with a MS Access file on another machine


: I'm busy with a school project and I want to know
: "if and how it is possible to connect to a MS Access file on another PC
: using OLEDB"
:
: I have looked in many places on the internet, but they all came up with
files on the same machine.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~