Print Page | Close Window

I need help (MS Access),

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=4748
Printed Date: 30 June 2024 at 11:45am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com


Topic: I need help (MS Access),
Posted By: migue
Subject: I need help (MS Access),
Date Posted: 06 August 2006 at 3:58pm
I want to work with MS Access but my database has got a password ... How can I create the provider with password in your connection... I've tried with this sentence but doesn´t work:
 
      OpenProvider "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & cadena & ";Persist Security Info=False;Jet OLEDB:Database Password=xxx"
 
Thanks..
 
   Miguel



Replies:
Posted By: PeySoft
Date Posted: 07 August 2006 at 11:04am
Hi Mique

I would suggest you simply use the Access Application object. If your tables are linked then this should work since Access is handling the data connection through the application object. SO

CalendarControl1.SetDataProvider Application.CurrentDB
 
should work


-------------
MS Access Expert
(or trying to be!)


Posted By: sserge
Date Posted: 08 August 2006 at 2:22pm
see also http://forum.codejock.com/forum_posts.asp?TID=3183 - http://forum.codejock.com/forum_posts.asp?TID=3183

--
WBR,
Serge


Posted By: sserge
Date Posted: 24 August 2006 at 4:55am
http://forum.codejock.com/forum_posts.asp?TID=3989&PID=15177#15177 - http://forum.codejock.com/forum_posts.asp?TID=3989&PID=15177#15177




Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.04 - http://www.webwizforums.com
Copyright ©2001-2021 Web Wiz Ltd. - https://www.webwiz.net