Codejock Developer Community : Multi-User Access DB - Best method - Please Help http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 30 May 2026 04:47:12 +0000 Tue, 09 Oct 2007 16:33:51 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=8352 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Multi-User Access DB - Best method - Please Help : You can use regular Access data...]]> http://forum.codejock.com/forum_posts.asp?TID=8352&PID=27138&title=multiuser-access-db-best-method-please-help#27138 Author: sserge
Subject: 8352
Posted: 09 October 2007 at 4:33pm

You can use regular Access data provider for all your tasks, except: "and I'd like to use an 'employees' table instead of yourresources table for resources". The problem is that all table names are hardcoded.

To use another names (and/or data structure), you have to implement custom data provider as described in the article, including writing of custom SQL scripts, and so on.

--
WBR,
Serge
]]> Tue, 09 Oct 2007 16:33:51 +0000 http://forum.codejock.com/forum_posts.asp?TID=8352&PID=27138&title=multiuser-access-db-best-method-please-help#27138 <![CDATA[Multi-User Access DB - Best method - Please Help : I&#039;ve read your article: h...]]> http://forum.codejock.com/forum_posts.asp?TID=8352&PID=27097&title=multiuser-access-db-best-method-please-help#27097 Author: vbuser
Subject: 8352
Posted: 09 October 2007 at 2:17am

I've read your article: http://codejock.com/support/articles/com/calendar/cp_3.asp
 
I am still not clear what the best and simpler method is; can you please give me your recommendation, bound, memory, etc.
 
I have a working VB6 demo app using the built-in access data provider. This app. will be used in a multi-user enviroment, I also like to add custom fields and I'd like to use an 'employees' table instead of your resources table for resources... Should I work with data in memory & save every time there is a change? Should I modify the SQL custom class to use Access instead, I dont really want to create myselft a big  mess of a problem hard codeing all this if I could find a way around to use the built-in access provider and just use some code to 'adapt' to my needs... I could just keep the resources table and update it from my 'employees' table for example.
 
When is best to refresh/re-load data to make sure all computers can see the current calendars? Can you give me an example? Thank you!
]]> Tue, 09 Oct 2007 02:17:35 +0000 http://forum.codejock.com/forum_posts.asp?TID=8352&PID=27097&title=multiuser-access-db-best-method-please-help#27097