|
#1
February 1st, 2007, 09:34 AM
|
|||
|
|||
|
Editing the shared record
Dear Friends
Please helpme. Well I have a developed an application under VB studio 2005 for processing the sales order and deployed it over the shared network. I have used ADODB to connect to MS Access table over the shared network. Now I am having a problem with the master table - which is required to update the currentstock data field. The stock master doesnot get update if accessed by more then one salesmen over the network. I hve tried following but doesnt work: rst.Update Connect.CommitTrans Thanks 
|
|
#3
February 5th, 2007, 09:24 AM
|
||||
|
||||
|
The simple answer is, don't use Access. It's not great for handling concurrency or multiple users, and certainly isn't recommended for business-level use.
The long answer is, check the menu in Tools->Options->Advanced (in Access). There's several options regarding record access and locking in there that you'll want to setup for your required usage. You'll want to set it so no more than one user can open a record for editing simultaneously. There's no way to get it to detect changes and refresh dynamically in any database, that's the purpose of record locking.
__________________
Oracle's backup tutorial "A lot of people say games are addictive. Well, they're addictive in the sense that anything you like doing you repeat endlessly. But no one would say, 'Mr Kasparov, you have a chess problem,' or 'Tiger Woods, you have a golf addiction.'" - Ian Livingstone, Creative Director, Eidos. "A problem well stated is a problem half solved" - Charles Franklin Kettering
|
 |
| Bookmarks |
«
Previous Topic
|
Next Topic
»
| Topic Tools | |
|
|
All times are GMT +1. The time now is 12:50 AM.
[
RSS ]
