Create Table SQL

[libraccess]

Problem :
I have two charts that I can only get to work by running an append query to a Temporary table
(of course this is a bad move as I delete the records each time and Compact on close)
so it worked but is not good practice.
So I thought I'll run the two charts in a separate database link to the tables i need and open up the DB from a button in my reports menu
This works, (this is a distributed application) of course I have to set the path for each users machine (painful) and then until someone decides to move a folder and the path specified is then incorrect. Then it does not.

Now I've never used a CreateTable in SQL but I'm thinking maybe this is a safe way to run the query to populate the table and not worry about the delete compact/repair problems.



Does this sound like it is worth persuing?

[June7]

Is the temporary table in the frontend?

That is the solution I use for several processes.

Consider UNC pathing for links to backend. Then user drive mapping is irrelevant.

[libraccess]

Yes temp table and delete, append queries are in the front end.
UNC pathing mmmm I'll have to look into that.
Although now after a chat here we think that only one front end (mine ) will run these charts once a month and filed as PDFs (with a few other reports) for the hoi polloi

So sort of solved for now Thanks again