Split Database Make-Table query problem

[Shaft]

Hi All,

I've developed a database that was working fine until I split it to use in a network enviroment. The problem is a make-table query that now make it's table in the front end instead of the back-end. I need to run a make-table query because the query uses a custom function which then causes errors when the query is accessed by a web form that I use.

The only way I thought of getting round it was to create a permanent table in the back-end which is cleared every time and an append query used to populate it.

Anybody any other ideas?

Cheers

 

[MStef]

Try this:
When you create Make Table query, you have to enter a
table name via popup form "Make Table".
In this form select "ANOTHER DATABASE", and populate the
path name of your BE. I think it must work.

 

[boblarson]

The only way I thought of getting round it was to create a permanent table in the back-end which is cleared every time and an append query used to populate it.

This is better than making a new table anyway. It will cause you less database bloat.

 

[MicroE]

I would choose the delete query/append query approach over using the make-table query method. Using a make-table query to add a table to the backend db will potentially result in more errors. If a user has the table open, the make-table will fail - however, the delete/append would succeed.