MultiUser and a MakeTable Query

[Deirdre Marie]

Panic Mode=True

I've spent the past few weeks developing a database that uses some linked tables, append queries, delete queries and a MakeTable query.

It all works splendid when little ol' me is using it, however it's time for it to go "live" and after reading all the benefits of splitting your database, I've chosen to do so.

However, now that I've split my test copy of the database, the append queries have caused an error as well as the MakeTable query.

Is there help for this? Do I need to do somethign extra for a multi-user database that utilizes all these different queries? Or shall I trod back to square 1?

Your assistance is very much appreciated.

 

[ghudson]

I prefer not to use make table queries if I know the table will always be used. I suggest that you clear the table of the data before running an append query.

This will delete the records from the "TestTable"...
Currentdb().Execute "DELETE * FROM TestTable"

You mentioned that you split the db. Does your front end know where the back end is? From the menu bar, click >>> Tools \ Add-Ins \ Linked Table Manager to refresh your linked tables.

HTH