Codejock Developer Community : Connection http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 13 May 2026 10:01:03 +0000 Sat, 25 Nov 2006 09:55:13 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=5554 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Connection : For those who may need to connect...]]> http://forum.codejock.com/forum_posts.asp?TID=5554&PID=17610&title=connection#17610 Author: rgracie
Subject: 5554
Posted: 25 November 2006 at 9:55am

For those who may need to connect to a user secured Access db, here is the correct connection string to allow for this...

Special Thanks To Sergey in Technical..

";User ID=xxx;Password=yyy;"

.SetDataProvider CStr(Application.ADOConnectString + ";User ID=administrator;Password=adminpassword;")

OR 

 .SetDataProvider CStr(Application.ADOConnectString & ";User ID=administrator;Password=adminpassword;")

Robert


]]> Sat, 25 Nov 2006 09:55:13 +0000 http://forum.codejock.com/forum_posts.asp?TID=5554&PID=17610&title=connection#17610 <![CDATA[Connection : Can someone post an example of...]]> http://forum.codejock.com/forum_posts.asp?TID=5554&PID=17528&title=connection#17528 Author: rgracie
Subject: 5554
Posted: 21 November 2006 at 8:12pm

Can someone post an example of a working connection string used to make connection to a user secured MS Access database, that includes username and password?

Robert
]]> Tue, 21 Nov 2006 20:12:53 +0000 http://forum.codejock.com/forum_posts.asp?TID=5554&PID=17528&title=connection#17528 <![CDATA[Connection : I&#039;m not sure how the...]]> http://forum.codejock.com/forum_posts.asp?TID=5554&PID=17451&title=connection#17451 Author: rgracie
Subject: 5554
Posted: 19 November 2006 at 3:03pm

I'm not sure how the control is interpreting the string thatis passed, but it must be relying on the default system.mdw security file andpermissions ??


Is there an error object somewhere hidden, as I don’t see any.

 

I tested this control fairly well (actually built 95% of my equipments) in the default sample container, evensplitting the table out from the container. I would have never guessed thatsecurity would be the problem that it has become…

 

I hope we can find a resolution quickly, as I’m due torelease first week on Dec.

 
Thanks

Robert

]]> Sun, 19 Nov 2006 15:03:40 +0000 http://forum.codejock.com/forum_posts.asp?TID=5554&PID=17451&title=connection#17451 <![CDATA[Connection : Indeed, but it does not work when...]]> http://forum.codejock.com/forum_posts.asp?TID=5554&PID=17449&title=connection#17449 Author: rgracie
Subject: 5554
Posted: 19 November 2006 at 2:28pm

Indeed, but it does not work when I use it in a user secured setup..

Robert
]]> Sun, 19 Nov 2006 14:28:34 +0000 http://forum.codejock.com/forum_posts.asp?TID=5554&PID=17449&title=connection#17449 <![CDATA[Connection : Hi,Have you looked into Calendar...]]> http://forum.codejock.com/forum_posts.asp?TID=5554&PID=17448&title=connection#17448 Author: sserge
Subject: 5554
Posted: 19 November 2006 at 2:25pm

Hi,

Have you looked into Calendar Access sample? ToolkitPro\Samples\ActiveX\Calendar\Access\AccessSample.mdb

It connects using:

Me.CalendarControl1.SetDataProvider Application.ADOConnectString


--
WBR,
Serge
]]> Sun, 19 Nov 2006 14:25:26 +0000 http://forum.codejock.com/forum_posts.asp?TID=5554&PID=17448&title=connection#17448 <![CDATA[Connection : From within MS Access 2002Front...]]> http://forum.codejock.com/forum_posts.asp?TID=5554&PID=17434&title=connection#17434 Author: rgracie
Subject: 5554
Posted: 18 November 2006 at 7:48pm

From within MS Access 2002
Front End / Back End Design
User Level Security Active Through non system .mdw "SXPDEVSECV3.mdw"

How does one connect the data provider?

I have tried

Application.ADOConnectString
CurrentDb.Name

The odd thing is that even if I enter the wrong connection string in the Access container that works,

PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=C:\Program Files\ServiceXp\servicexpv3.mdb;PERSIST SECURITY INFO=FALSE;Jet OLEDB:System database=C:\Program Files\ServiceXp\SXPDEVSECV3.mdw

it still finds the correctly linked tables in..

PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=C:\Documents and Settings\Robert\Desktop\AccessSample.mdb;PERSIST SECURITY INFO=FALSE;Jet OLEDB:System database=C:\Documents and Settings\Robert\Application Data\Microsoft\Access\System.mdw

?????

Robert

]]> Sat, 18 Nov 2006 19:48:05 +0000 http://forum.codejock.com/forum_posts.asp?TID=5554&PID=17434&title=connection#17434