Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Sub Form in Multi User Environment

Author  Topic 

JTProg
Starting Member

24 Posts

Posted - 2006-08-16 : 15:59:22
Using ADP and SQL Server: What is the best approach when using subforms for data entry instead of just the normal edit routines. I'm using this application in a multi-user environment. I want to avoid dead locks, table locks, etc ......... I have the data entry property set to yes, but what other steps are necessary when using subforms in multi user environments. Normally, I avoid subforms but I really need this due to the amount of controls on the form.

stephenbaer
Yak Posting Veteran

71 Posts

Posted - 2006-09-07 : 11:59:54
Just out of curiosity, how do you manage to avoid subforms? Do you create custom views? I've been using a lot of subforms lately, and it makes everything really hard. Especially when the height of the subform is a single row, and I have to keep resizing it to work on it.
Go to Top of Page
   

- Advertisement -