Accessing Access Database

[jim]

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

[Arthur Wood]

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

[Jim]

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
>

[Arthur Wood]

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
>>
>

[Jim]

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
>>>
>>
>

[Arthur Wood]

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
>>>>
>>>
>>
>