How to make a non ODBC connection?

[JennyPeters]

I'm trying to connect to a MS Access database that will eventually be on another computer on the network, from an Outlook form.

I've looked everywhere for a simple connection VBScript that does not use the ODBC connection method as the database will not be on my computer.

Can any one show me a simple script for this purpose?

Thanks,

Jenny

 

[Guest_imported]

If you are using ADO, try below:

Dim cn as Connection
Set cn = New Connection
With cn
.Provider = "Microsoft.Jet.OLEDB.3.51"
.ConnectionString = "e:\mydb.mdb"
.Open
End With

You need to map the network drive where the mdb file resides. Hope this will help.