!!! ERROR 3008 I NEED HELP NOW!!!!!!!!!

[Mark H]

I have a field in a form named "Project Name" which is in
my main form named "projects'. I then have a subform for
the for the time and expenses. I am trying to sort my
records by "Project Name" and then have for each record a
listing in the subform for the Time and Expenses for that
project name. My problem is that when I set up the form
based on the projects I got the following error message.

"The Table 'Projects' is already opened exclusively by
another user, or it is already open through the user
interface and cannot be manipulated programmatically."
PLEASE, help me figure out how to fix this

Very desperate

Mark H

 

[Ken Snell]

Is the subform based on a query that uses both the "projects" table and the
"child" table in which you're storing "time" and "expenses"? Or is the
subform based on the "projects" table and you're storing the "time" and
"expenses" in that same table?

Without knowing much more about your table and form setups, I'm guessing
that you're trying to use the same table in both the subform and the main
form.

If you can post more info, I'm sure we can help identify the cause of the
error message.

 

[Mark H]

Hi Ken,
Thanks so much for your response. After looking at my
form again , I found that I had no query based on the
form Projects". The subform is based upon the
table "Projects" and I have no field that store
the "time" and "expenses" in that table. "Time"
and "Expenses" are based on two separate
Subforms, "Projects Subform" (Time) and "Projects Expense
Subform" (Expenses) What would you recommended that I do
to correct this problem. I am going to to try and set up
a query based on "projects". In that query I will add the
table "projects" and add the query for the two separate
subforms. Please respond ASAP as to what your
recommendations would be. Thanks! Mark H

 

[Ken Snell]

Let's back up a moment. I am becoming confused about how your form is
actually set up.

In your original post, you mentioned that you have one subform on a main
form.

In this post, you appear to be saying that you have three subforms on a main
form?

So that I can visually "see" this in my head, please describe the exact
setup of the form, including what's on the main form and what are the
subforms and what is on them. Also, post what is the recordsource for the
main form and for the subform(s).

Also, it'll be helpful if you can restate what the form is trying to do --
what is to show, which data are to be displayed and/or edited and/or
entered, where are the data to be stored. It likely will be helpful as well
if you can describe the tables that you're using and the structure (fields,
type of fields, etc.) in those tables.

Thanks.

 

[Mark H]

Ken,

My problem has been corrected, Thanks!

I just have one other question. On my main form I have a
control button to preview my invoices from the form
named "projects" after enteriing data in this form, I
want to look at the data. When i click the button I get
the error message 3008 as below. If i dont enter anymore
data and just preview the invoice i get not error
message. How can I correct this?

Thanks! Mark H

 

[Ken Snell]

Error 3008 by itself is not specific enough for me to know what error is
occurring. Please post the actual error message that you're getting.

Are all the controls that contain the edited data and the command button on
the main part of the form?

 

[Mark H]

Hi Ken,

The actual error message that I receive is:

"The Table 'Projects' is already opened exclusively by
another user, or it is already open through the user
interface and cannot be manipulated programmatically."

I have a form named 'Clients'. In that form I display
general data such as name, address, etc. which is pulled
from another form. Everything is fine with that. At the
bottom of the 'Clients' form there are four command
buttons that open four separate forms named 'invoice' or
(projects), 'time cards', 'payments', and 'preview
invoice'. The first three Command buttons work with no
problem. The problem is in the last command button. It
gives me the above error message.

 

[Ken Snell]

In your earlier posts, you mentioned that Projects table is the basis of a
subform on this form? As such, that table is "open" via that subform. If you
are editing a record in that subform, and then try to open the table "again"
using another form while the record is still being edited, you can get this
locking error message that you're seeing.

I'm still not sure if the command button is on the main part of the form or
on the subform?