Re: Use ADO in Access 2000?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Douglas J. Steele (NOSPAM_djsteele_at_NOSPAM_canada.com)
Date: 06/14/04 

Date: Mon, 14 Jun 2004 18:31:53 -0400

What permissions do you have on the folder in which the MDB exists? You must
have Read, Write and Delete.

And why are you trying to avoid DAO? For Jet databases (i.e.: MDB files),
it's still the better way. 

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"dj" <dj@discussions.microsoft.com> wrote in message
news:0EB7C8B4-7659-4D1B-9A1C-F8E52E93EDCD@microsoft.com...
> This seems so simple, yet I can't seem to work it out.
> I have an Access 2000 database open.
> I want to connect to the database and append to a table using ADO.
> When I try to open the ADO Connection, I get the error message 'The
database has been placed in a state by user 'Admin' on machine 'MYMACHINE'
that prevents it from being opened or locked.'
>
> I experimented with the Mode settings of the Connection object to no
avail.
> I have a reference set to the ADO 2.8 library, no DAO reference - I'd like
to avoid DAO.
> Can anyone tell me what I'm missing?
>
> TIA,
> dj

Relevant Pages

  • Re: Suggestoins for Local DB to use with Shareware
    ... It was with D3 - I was using the BDE at the time. ... As for my own experience I begin to evalute ADO with Access ... MDB files in D4 just before D5 appeared with built in ADO support what has ... local database engines and I will continue to use it in the future. ...
    (borland.public.delphi.non-technical)
  • Re: database method?
    ... > I'm writing a stand-alone application to connect to a database ... Access to work with the MDB from VB. ... ADO would be more flexible. ... Jet is a poor choice for client/server ...
    (microsoft.public.vb.database)
  • Re: Making mdb read-only after appending tables
    ... Temp objects are deleted when the database is ... But VB programmers were confused by the name of the ... There may be a way to set this property using ADO. ... The mdb has to be deleted after processing is finished. ...
    (microsoft.public.access.security)
  • Re: DLookup function
    ... > linked) or saved query in your current database. ... >> I have an MDB with my tables and then a seperate MDB with the forms, ... I am using ADO for my database connections etc. ...
    (microsoft.public.access.gettingstarted)
  • Use ADO in Access 2000?
    ... >I have an Access 2000 database open. ... using ADO. ... >I have a reference set to the ADO 2.8 library, ... reference - I'd like to avoid DAO. ...
    (microsoft.public.access.modulesdaovba)