|
Connection |
Post Reply 
|
| Author | |
rgracie 
Groupie 
Joined: 12 November 2006 Status: Offline Points: 75 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: ConnectionPosted: 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 |
|
 |
|
|
sserge
Moderator Group 
Joined: 01 December 2004 Status: Offline Points: 1297 |
Post Options
Thanks(0)
Quote Reply
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:
-- WBR, Serge |
|
|
|
|
rgracie
Groupie
Joined: 12 November 2006 Status: Offline Points: 75 |
Post Options
Thanks(0)
Quote Reply
Posted: 19 November 2006 at 2:28pm |
|
Indeed, but it does not work when I use it in a user secured setup..
Robert |
|
|
|
|
rgracie
Groupie
Joined: 12 November 2006 Status: Offline Points: 75 |
Post Options
Thanks(0)
Quote Reply
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 ??
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.
|
|
|
|
|
rgracie
Groupie
Joined: 12 November 2006 Status: Offline Points: 75 |
Post Options
Thanks(0)
Quote Reply
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 |
|
|
|
|
rgracie
Groupie
Joined: 12 November 2006 Status: Offline Points: 75 |
Post Options
Thanks(0)
Quote Reply
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 |
|
|
|
|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
Topic Options