[AccessD] Connection String syntax

Thanks A Million !

Happy Holidays!!

Robert 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MartyConnelly
Sent: Sunday, November 19, 2006 2:29 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Connection String syntax

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#OLEDBProviderForMicrosoftJ
et

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"


Robert wrote:

>What is the correct syntax when opening from within a FE/BE MS Access 
>when user security has been moved to a difference, non system, .mdw?
>
>This does not seem to do it..
>
>"PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=CurrentProject.Path & 
>FEDBName;User Id=administrator; Password=adminpassword"
>
>Thanks
>
>Robert
>
>  
>

--
Marty Connelly
Victoria, B.C.
Canada

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