Accessing Access Database


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 6 of 6

Thread: Accessing Access Database

  1. #1
    jim Guest

    Accessing Access Database


    Good Morning,

    I'm working in an upload button in an Access 2000 Database and I'm trying
    to access information in a table in the database and it keeps telling me
    "Database is currently in use". How do access information in the table when
    the database is in use?? Any help would be great...

    Thanks..

    Jim

  2. #2
    Arthur Wood Guest

    Re: Accessing Access Database


    Jim,

    When you say "upload" are you attempting to Insert new data into the
    database? Or are you simply reading data from an existing table?

    Arthur Wood


    "jim" <jcb1269@excite.com> wrote:
    >
    >Good Morning,
    >
    > I'm working in an upload button in an Access 2000 Database and I'm

    trying
    >to access information in a table in the database and it keeps telling me
    >"Database is currently in use". How do access information in the table

    when
    >the database is in use?? Any help would be great...
    >
    >Thanks..
    >
    >Jim



  3. #3
    Jim Guest

    Re: Accessing Access Database


    What I'm trying to do is upload records to a file from a button called upload
    in a form. It's accessing records from a table called yrad inside the sames
    database.

    Thanks..

    Jim

    "Arthur Wood" <wooda@saic-trsc.com> wrote:
    >
    >Jim,
    >
    > When you say "upload" are you attempting to Insert new data into the
    >database? Or are you simply reading data from an existing table?
    >
    >Arthur Wood
    >
    >
    >"jim" <jcb1269@excite.com> wrote:
    >>
    >>Good Morning,
    >>
    >> I'm working in an upload button in an Access 2000 Database and I'm

    >trying
    >>to access information in a table in the database and it keeps telling me
    >>"Database is currently in use". How do access information in the table

    >when
    >>the database is in use?? Any help would be great...
    >>
    >>Thanks..
    >>
    >>Jim

    >



  4. #4
    Arthur Wood Guest

    Re: Accessing Access Database


    Jim,
    I am still unclear. You say "upload records to a file", by that do you
    mean Upload records to a TABLE in the database?

    Arthur Wood


    "Jim" <jcb1269@excite.com> wrote:
    >
    >What I'm trying to do is upload records to a file from a button called upload
    >in a form. It's accessing records from a table called yrad inside the sames
    >database.
    >
    >Thanks..
    >
    >Jim
    >
    >"Arthur Wood" <wooda@saic-trsc.com> wrote:
    >>
    >>Jim,
    >>
    >> When you say "upload" are you attempting to Insert new data into the
    >>database? Or are you simply reading data from an existing table?
    >>
    >>Arthur Wood
    >>
    >>
    >>"jim" <jcb1269@excite.com> wrote:
    >>>
    >>>Good Morning,
    >>>
    >>> I'm working in an upload button in an Access 2000 Database and I'm

    >>trying
    >>>to access information in a table in the database and it keeps telling

    me
    >>>"Database is currently in use". How do access information in the table

    >>when
    >>>the database is in use?? Any help would be great...
    >>>
    >>>Thanks..
    >>>
    >>>Jim

    >>

    >



  5. #5
    Jim Guest

    Re: Accessing Access Database


    Ok, I have a database. In the database I have a table named yrad, there is
    a form in this database called form1. On form1 form there is a button called
    upload, when clicked, it will write the records from the yrad table to a
    Flat File (file.txt). Whenever I click this button, It tells me that the
    database is already in use and doen't work. What I'm trying to do is make
    this button(the code) not be concerned with wether or not the database is
    open. Hope this helps..

    Jim



    "Arthur Wood" <wooda@saic-trsc.com> wrote:
    >
    >Jim,
    > I am still unclear. You say "upload records to a file", by that do you
    >mean Upload records to a TABLE in the database?
    >
    >Arthur Wood
    >
    >
    >"Jim" <jcb1269@excite.com> wrote:
    >>
    >>What I'm trying to do is upload records to a file from a button called

    upload
    >>in a form. It's accessing records from a table called yrad inside the

    sames
    >>database.
    >>
    >>Thanks..
    >>
    >>Jim
    >>
    >>"Arthur Wood" <wooda@saic-trsc.com> wrote:
    >>>
    >>>Jim,
    >>>
    >>> When you say "upload" are you attempting to Insert new data into the
    >>>database? Or are you simply reading data from an existing table?
    >>>
    >>>Arthur Wood
    >>>
    >>>
    >>>"jim" <jcb1269@excite.com> wrote:
    >>>>
    >>>>Good Morning,
    >>>>
    >>>> I'm working in an upload button in an Access 2000 Database and I'm
    >>>trying
    >>>>to access information in a table in the database and it keeps telling

    >me
    >>>>"Database is currently in use". How do access information in the table
    >>>when
    >>>>the database is in use?? Any help would be great...
    >>>>
    >>>>Thanks..
    >>>>
    >>>>Jim
    >>>

    >>

    >



  6. #6
    Arthur Wood Guest

    Re: Accessing Access Database


    Jim,

    I am beginning to get the picture. All of this is transpiring in an Access
    Database, with a form which is IN THAT database. Correct so far?

    What code do you have in the OnClick Event of the Command Button?

    Can you post a copy of the relevant VBA code?

    Arthur Wood


    "Jim" <jcb1269@excite.com> wrote:
    >
    >Ok, I have a database. In the database I have a table named yrad, there

    is
    >a form in this database called form1. On form1 form there is a button called
    >upload, when clicked, it will write the records from the yrad table to a
    >Flat File (file.txt). Whenever I click this button, It tells me that the
    >database is already in use and doen't work. What I'm trying to do is make
    >this button(the code) not be concerned with wether or not the database is
    >open. Hope this helps..
    >
    >Jim
    >
    >
    >
    >"Arthur Wood" <wooda@saic-trsc.com> wrote:
    >>
    >>Jim,
    >> I am still unclear. You say "upload records to a file", by that do

    you
    >>mean Upload records to a TABLE in the database?
    >>
    >>Arthur Wood
    >>
    >>
    >>"Jim" <jcb1269@excite.com> wrote:
    >>>
    >>>What I'm trying to do is upload records to a file from a button called

    >upload
    >>>in a form. It's accessing records from a table called yrad inside the

    >sames
    >>>database.
    >>>
    >>>Thanks..
    >>>
    >>>Jim
    >>>
    >>>"Arthur Wood" <wooda@saic-trsc.com> wrote:
    >>>>
    >>>>Jim,
    >>>>
    >>>> When you say "upload" are you attempting to Insert new data into

    the
    >>>>database? Or are you simply reading data from an existing table?
    >>>>
    >>>>Arthur Wood
    >>>>
    >>>>
    >>>>"jim" <jcb1269@excite.com> wrote:
    >>>>>
    >>>>>Good Morning,
    >>>>>
    >>>>> I'm working in an upload button in an Access 2000 Database and

    I'm
    >>>>trying
    >>>>>to access information in a table in the database and it keeps telling

    >>me
    >>>>>"Database is currently in use". How do access information in the table
    >>>>when
    >>>>>the database is in use?? Any help would be great...
    >>>>>
    >>>>>Thanks..
    >>>>>
    >>>>>Jim
    >>>>
    >>>

    >>

    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center