Re: Recommendation for database access

ADO.NET has a BIG advantage over ADO classic. It's not COM-based when used
with any a managed provider. This means that once an application is
installed, it keeps working--even when other DLLs are loaded on the system
that this application would ordinarily use. We get dozens of complaints a
month about situations such as yours. Stuff working but not now. Stuff
working on one system but not others. Slow stuff, locked stuff, corrupted
stuff. SQL Server and ADO.NET were designed to address these issues.
Developers should take advantage of the light provided by these innovations
instead of cursing the darkness.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"code3_brent" <code3brent@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FD5E7FB8-7DC6-4DC2-872D-6BD51605B082@xxxxxxxxxxxxxxxx
> I've been through all of this initially. It is not consistent, so if I
> made a
> change, it may be a month before it crops up again. But when it happens,
> it
> is a critical app. So I need to find an alternative.
>
> "Stephen Howe" wrote:
>
>> > This application was running fine for over a year. All of the sudden,
>> > the
>> > client started to get errors that said that the database was in use by
>> > another user and couldn't be opened.
>>
>> Ask them questions:
>>
>> 1) Are they all experiencing this problem or does it happen to be a
>> particular user(s) or a particular PC(s)?
>> 2) If it is a few PC(s) find out if anything has changed recently on the
>> PC's, other than the new antivirus program
>> 3) Ask them if they could try using your product with the antivirus
>> disabled. Does it suddenly rework?
>> 4) If the antivirus product is enabled, is it enabled to scan all disk
>> access? If so, can the database be excluded from the scanning (usually
>> you
>> can).
>>
>> Stephen Howe
>>
>>
>>


.

Relevant Pages

  • Re: Recommendation for database access
    ... > client started to get errors that said that the database was in use by ... Ask them if they could try using your product with the antivirus ... If the antivirus product is enabled, is it enabled to scan all disk ... can the database be excluded from the scanning (usually you ...
    (microsoft.public.data.ado)
  • Re: Recommendation for database access
    ... "Stephen Howe" wrote: ... > 3) Ask them if they could try using your product with the antivirus ... > 4) If the antivirus product is enabled, is it enabled to scan all disk ... can the database be excluded from the scanning (usually you ...
    (microsoft.public.data.ado)
  • Re: Puter dummy needs help
    ... What antivirus product do you have installed already, ... * Use a good firewall to block access to your computer from the Internet ... For a good hardware firewall, see NetGear or Linksys or DLink - they all ...
    (microsoft.public.security.virus)
  • Re: 75 second delay accessing a proprietary (unknown) medical database
    ... Even though the mapped drive to the server holding the medical database was ... option in the "Advanced" section was selected in the antivirus client's real ... Removing the check box to "Protect Network Drives" ...
    (microsoft.public.windows.server.sbs)
  • access problem please i need your help
    ... database windowthere are problem in open event or change event ... reinstall antivirus does it help me or not. ... please help im focusing in the first problem then the second one ...
    (comp.databases.ms-access)