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"


.

Relevant Pages

  • Re: Accessing MS Access Remotely
    ... Phyxious schrieb: ... connect to a Access database in a script on a remote server? ...
    (microsoft.public.scripting.wsh)
  • Re: Word 2000/2002 - Proper Mail Merge steps for ODBC?
    ... > Document to connect to a Secured Access Database, ... using the ODBC provider for OLEDB. ... they have a .dsn extension. ... directly (in the Open/Select Data Source dialog box). ...
    (microsoft.public.word.mailmerge.fields)
  • RE: remote scripting how to
    ... I re-engineered the following script from the example ... if i check taskmanager i can see the exe sitting there on the ... remote server but not doing what its supose to do, ... > will launch a file remotely on a machine, or copy the file to launch on the ...
    (microsoft.public.windows.server.scripting)
  • Re: how to encrypt password stored in ftp script
    ... I need that script to run everyday automatically on machine ... people form modifying script to access the FTP server for different ... Hiding your username and password in this circumstance is impossible ... include this in a form that can be read by the remote server. ...
    (comp.lang.perl.misc)
  • Re: ADO and blank fields problem
    ... > Charles E Finkenbiner wrote: ... >>My script is a front end for an MS Access database. ... not the internet. ...
    (microsoft.public.scripting.vbscript)