Make New Table in Front End When Back End Is Open

[johnsqftwr]

I have a Front End Database and a Back End Database.

Certain tables in the BE are linked to the FE.

Once or twice a day I need to run Make Table Queries in the FE, but I am unable to do so if someone else has the BE open.

Best solution would be greatly appreciated

Many thanks

John

 

[Dennisk]

what is the error message?

 

[johnsqftwr]

Thanks for reply.

I get to work in about 3 hours time and will report error message then.

Many thanks

 

[johnsqftwr]

The error message is:

Could not lock 'tablename'; currently in use by usere 'UserName' on machine ''

 

[Dennisk]

In order for a make table to work it has to replace table, this suggests that you have a user who has the table open. When you say 'user who has the be open' are they opening the be of fe and all your tables are linked through the FE.

If the data to append to table is always the same columns then
normally you would run a delete query then an append query.

 

[johnsqftwr]

Correct I have a user in the BE with the table open. When I try to replace the table in the FE by the Make Table Query I get the error.

The columns are always the same, so I will try your suggestion and run a delete query and the an append query in the FE.

 

[KeithG]

Is this table a linked table?

 

[johnsqftwr]

Yes, the table is linked from the FE to the BE

 

[johnsqftwr]

Many thanks for your help.

Yes, the answer was to run 2 queries for updating each table.
A Delete Records Query and an Append Records Query rather than a Make Table Query.

These queries run succesfully while the BE is open.

Regards


John