locked tables

[rafik]

I have a database split in BE & FE. when any user open the FE they lock the
tables in the BE. This does not allow me to run the code to delete and
recreate the tables by create table Query.
My question is:
1- Is there a way to not allow any user to lock the BE tables used in the FE
forms?
2- If not 1 then can you show me the code to tell me who has the BE Locked?

Thank you

 

[Alex Dybenko]

Hi,
why do you need to delete/recreate tables? looks like a wrong approach.
Consider to delete and insert records instead

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[DaveT]

You might take a look at:

How to determine who is logged on to a database by using Microsoft Jet
UserRoster in Access

http://support.microsoft.com/kb/285822/

 

[rafik]

Thank you for your help
Delete and insert records would work ecxept the table I'm Trying to update
is created with a union Query. is there a way to create an insert record with
a union query

strSQL = "INSERT INTO TableC (Field1, Field2" & _
"SELECT Field1, Field2 FROM TableA " & _
"union select Field1, Field2 FROM tableB"

 

[Alex Dybenko]

Hi,
try the following:
INSERT INTO TableC (Field1, Field2)
SELECT Field1, Field2 FROM
(SELECT Field1, Field2 TableA union select Field1, Field2 FROM tableB) as u

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com