Link to MS Access

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

Does anyone have any samples linking to a MS Access Database with VB. NET frontend?

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
visualise01 Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 20 September 2009 Location: United Kingdom Status: Offline Points: 7	Post Options Post Reply Quote visualise01 Report Post Thanks(0) Quote Reply Topic: Link to MS Access Posted: 12 October 2009 at 1:10pm
	Does anyone have any samples linking to a MS Access Database with VB. NET frontend?

SuperMario Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 14 February 2004 Status: Offline Points: 18057	Post Options Post Reply Quote SuperMario Report Post Thanks(0) Quote Reply Posted: 13 October 2009 at 2:49pm
	Our VB.NET calendar sample shows exactly how to do this. Run the sample, choose File->Open and select MS Access Database.

visualise01 Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 20 September 2009 Location: United Kingdom Status: Offline Points: 7	Post Options Post Reply Quote visualise01 Report Post Thanks(0) Quote Reply Posted: 16 October 2009 at 2:29pm
	There must be a simpler example availabe - I have used the code supplied with the examples, but cant get it to work. All I want to do it be able to add new calendar events to the calendar and database and have existing events load into the calendar from the database, also have recurring work. I dont want options to pick datasource.

SuperMario Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 14 February 2004 Status: Offline Points: 18057	Post Options Post Reply Quote SuperMario Report Post Thanks(0) Quote Reply Posted: 16 October 2009 at 3:52pm
	strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='C:\Program Files\Codejock Software\ActiveX\Xtreme SuitePro ActiveX v13.2.0\Samples\Calendar\events.mdb';" If CalendarControl.DataProvider.IsOpen Then CalendarControl.DataProvider.Save() End If CalendarControl.SetDataProvider(strConnectionString) If Not CalendarControl.DataProvider.Open Then If Not CalendarControl.DataProvider.Create Then System.Diagnostics.Debug.Assert(False, "") End If End If CalendarControl.Populate()