Re: Recommendation for database access

Hi,

I do not think using ADO.NET will help. I would try to switch to MSDE
database from Access. First of all it is more stable. Also it is more
scalable and has much more functionality. Of course it depends on if you
could do this or not.

--
Val Mazur
Microsoft MVP

http://xport.mvps.org



"code3_brent" <code3brent@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:848C59B3-CF68-4A05-8073-826B112DCD70@xxxxxxxxxxxxxxxx
>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

  • Resolving temp table locking issues
    ... tables frequently against a SQL Server 2000 database. ... performance issues and locking problems with temp tables. ... Another specified the tempdb is locked only while the ... Still another said it was locked during a transaction. ...
    (microsoft.public.vb.database.ado)
  • Re: Data corruption with SQL server installed
    ... I noticed that the rogue Primary key that appeareed with the .AddNew method ... The installation of MSDE comes after the installation of MDAC 2.8, ... you could create an empty database and import everything into ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Put database on Internet
    ... > Once you will be able to connect to MSDE or to SQL-Server, ... > and ADP in the same time as frontends to your database. ... >> will be able to serve as SQL server. ...
    (microsoft.public.access.dataaccess.pages)
  • Re: same old "Data has been changed error message", way around this?
    ... form, closing the database, finding or moving to another record, setting the ... Im searching for records, viewing results in a listbox, ... -Wants to run a report of only SOME of the matching records, ... Ideally I would just switch this ...
    (microsoft.public.access.formscoding)
  • Re: Connect to Access Data from various regional locations
    ... All users will be connecting via broadband. ... When using MSDE ... > Dim rf As DAO.Recordset ... > There is a wizard to split your database into a FE and a BE; ...
    (microsoft.public.access.externaldata)