[AccessD] Connection String syntax

funny I have never been able to get windows to do that. Creating the text file then changing the name and then using that to create the connection. Never works for me.
 
Maritn
 
Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast
 
tel: 02890 974477
 

________________________________

From: accessd-bounces at databaseadvisors.com on behalf of ssharkins at setel.com
Sent: Sun 19/11/2006 19:38
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Connection String syntax



YOu can use Windows to create most connection strings -- I wonder if that
technique would apply here too?

Susan H.


 Carl Prothman has a site that provides ADO connection strings for a
> wide variety  of databases and providers. Even though he has
> switched over to the dark side.
>
> http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForMicrosoftJet
>
> If using a Workgroup (System Database)
>
> oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
>            "Data Source=c:\somepath\mydb.mdb;" & _
>            "Jet OLEDB:System Database=MySystem.mdw", _
>            "myUsername", "myPassword"
>
>

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com <http://www.databaseadvisors.com/>