Runtime error '3009'

[erick-flores]

Hello all

I have this application in Access 2003. I am getting this runtime
error '3009' when a user already have one of the table open. I know
what is the problem, I just need to know how to create and If
statement that says;

If the table is in used then
do not run query
else
run query
end if

The problem is, everytime the application is open a make-table query
is executed. So obviously if a user has the table open and in use,
another user will no able to run the make-table query because this
query delete the existing one to create a new/current one. That is why
I need to write an IF statement to manipulate this situation.

Can somebody help me to write the correct If stat please???

 

[Guest]

Hi erick-flores,

Why is your database creating a new table on open? If it is necessary for a
temp table or something, you need to split the database and give each user
their own copy of the front end, where they can create the temp table with
impunity.

Damian.

 

[erick-flores]

Hi erick-flores,

Why is your database creating a new table on open?

Because the table where I am pulling the data from is a link table, I
create a make-table query from this link table so it sits on the local
databse. I do this because I have multiple calculations (counts, sum,
avg, etc) between forms if I use the link table then the calculations
will take forever.

If it is necessary for a
temp table or something, you need to split the database and give each user
their own copy of the front end, where they can create the temp table with
impunity.

Damian.

I dont quite understand your suggestion here, how do I split the
database?


Thanks

 

[erick-flores]

OK, so I split the database but it didnt work, looks like my link
tables didnt work with the split database feature. Any ideas?