-----------------------------------------------------------

New Message on MumbaiUserGroup

-----------------------------------------------------------
From: Jigs
Message 1 in Discussion


Hello Friends, 
  
I have a couple of issues. Please read its little long. I am describing a situation i 
am facing. 
 <o:p></o:p> 
A Web Page has many areas, which displays POLL; ADS; News etc each of this requires 
database access. I am using Access database and code for each of this areas is written 
in user controls. Every use control is using data adaptor and dataset to read and 
process data. 
 <o:p></o:p> 
Issues: Each of the controls has its own connection object too 
            Question: Can�t I have common connection for a page? 
Question Reason: Each user control is trying to open separate connection so at a 
                                         time I have 5 connection open for display 
single page.  
            Problem: Page Generates an Error: Unable to Lock file.   (Problem is 
arising bcos it not able to lock access db) 
            Observation: I separated news/ads/poll table and stored each in separate 
access DB. Now the page works fine. But this isn�t a solution to this problem. 
 <o:p></o:p> 
 <o:p></o:p> 
Question2: Can I specify sequence in which user control should execute? 
Question Reason: perhaps if I can specify this somewhere then I could tell the 
user control to wait until another finishes his work, thus above error can be 
controlled.  
 <o:p></o:p> 
Please Guide me to solve! 
  
 -Regards 
Jignesh<o:p></o:p> 
 <o:p></o:p> 
 

-----------------------------------------------------------

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/MumbaiUserGroup/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the "Remove" link below. On the pre-addressed 
e-mail message that opens, simply click "Send". Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]

Reply via email to