Recommendation for database access

I have a VB6 application written a few years ago that pulls data from an
Access database via ADO. There are about 15 users throughout a large network.
All data access is read only. Every single recordset is specified to open
read only.

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. I banged my head against the wall for
weeks trying to figure out what was going on, but couldn't find it. It was
not consistent and not re-creatable. The only thing that came up was about
the time this happened, they implemented a new antivirus program.

I created a temporary fix for it, but I am now going back to addess this
again. I thought of using ADO.NET, but am afraid I will eventually run into
the same issue. I have also thought of exporting all of the data to an XML
file, which shouldn't have any locking problems.

Just wanted to get some input as to how others thought I should proceed. I
need to charge them a fixed amount for the changes, so if I run into problems
again, I end up eating it.

Thanks for your input!
.

Relevant Pages

  • connecting Excel to Access through ADO
    ... I plan to put an Access database on a server, ... that pulls data from it via ADO. ... or is a copy of Excel all they will need? ...
    (microsoft.public.access.gettingstarted)
  • Re: Waiting for Powerpoint to finish
    ... > I need to wait for the Presentation to quit running (IE the user clicks ... >>> I have a VB.NET project that pulls data from an access database and creates a ... >>> exits before powerpoint is closed. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Waiting for Powerpoint to finish
    ... "Dan Artuso" wrote: ... >> I have a VB.NET project that pulls data from an access database and creates a ... >> exits before powerpoint is closed. ...
    (microsoft.public.access.modulesdaovba)
  • Re: How to connect MS ACCESS in Netwaork base VB6.0 Programme from server
    ... Structure you can use to connect to and query an Access Database using ADO. ... How to connect MS ACCESS in Netwaork base VB6.0 Programme from server ... SIDE) AND ATTENDENS STORE OM MS ACCESS DATABASE WHICH IS STORED ON ...
    (microsoft.public.vb.winapi)
  • Re: ADO and Active Server pages on a mac
    ... In otherwords does the Excel object model on a Mac have ADO? ... Here is how to create a connection to a MS Access Database: ... Does ADO only work on Active Server Pages on a PC? ...
    (microsoft.public.mac.office.excel)