Accessing MS Access Remotely   

I know MS Access is not designed for this purpose but is it possible to 
connect to a Access database in a script on a remote server?

date: Thu, 24 Jan 2008 12:47:17 -0800   author:   Phyxious

Re: Accessing MS Access Remotely   

Phyxious schrieb:
> I know MS Access is not designed for this purpose but is it possible to 
> connect to a Access database in a script on a remote server?

Map a drive (e.g. X:) to the server's directory containing the .mdb
and use

   sConn = "Provider=Microsoft.Jet.OLEDB.4.0;data source=X:\Test_Inventory.mdb"

date: Thu, 24 Jan 2008 22:04:51 +0100   author:   ekkehard.horner

Re: Accessing MS Access Remotely   

OK how about, is it possible to do it without mapping a drive or creating a 
DSN. Is there a way to it within the code?

"ekkehard.horner" wrote:

> Phyxious schrieb:
> > I know MS Access is not designed for this purpose but is it possible to 
> > connect to a Access database in a script on a remote server?
> 
> Map a drive (e.g. X:) to the server's directory containing the .mdb
> and use
> 
>    sConn = "Provider=Microsoft.Jet.OLEDB.4.0;data source=X:\Test_Inventory.mdb"
> 
>

date: Thu, 24 Jan 2008 18:14:01 -0800   author:   Phyxious

Re: Accessing MS Access Remotely   

Phyxious schrieb:
> OK how about, is it possible to do it without mapping a drive or creating a 
> DSN. Is there a way to it within the code?
> 
Try:

sConn =   "Provider=Microsoft.Jet.OLEDB.4.0;" _
         & "data source=\\<server>\<path>\Test_Inventory.mdb"

> "ekkehard.horner" wrote:
> 
>> Phyxious schrieb:
>>> I know MS Access is not designed for this purpose but is it possible to 
>>> connect to a Access database in a script on a remote server?
>> Map a drive (e.g. X:) to the server's directory containing the .mdb
>> and use
>>
>>    sConn = "Provider=Microsoft.Jet.OLEDB.4.0;data source=X:\Test_Inventory.mdb"
>>
>>

date: Fri, 25 Jan 2008 09:05:07 +0100   author:   ekkehard.horner