Calendar - Connection

Print Page | Close Window

Connection

Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Calendar
Forum Description: Topics Related to Codejock Calendar
URL: http://forum.codejock.com/forum_posts.asp?TID=5554
Printed Date: 05 July 2024 at 2:52pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Connection

Posted By: rgracie
Subject: Connection
Date 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

Replies:

Posted By: sserge
Date 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

Posted By: rgracie
Date Posted: 19 November 2006 at 2:28pm

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

Robert

Posted By: rgracie
Date Posted: 19 November 2006 at 3:03pm

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

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, even splitting the table out from the container. I would have never guessed that security would be the problem that it has become�

I hope we can find a resolution quickly, as I�m due to release first week on Dec.

Thanks

Robert

Posted By: rgracie
Date 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

Posted By: rgracie
Date 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