temporary files in access 2010
Posted on 2013-02-05
I want to split my database to work on allowing multiple and simultaneous access to the database. I haven't done this yet but I have a concern that I would like some feedback on. My concern is that the application requires the use of temporary table. This temp table is later appended to a permanent table. I want to split the database except for this temporary table which I would like to reside on the users PC. This temp table will be deleted the next time that person uses the application.
Basically, I want to split the database except for a temp table which I presume will be created on the user's PC.
Any ideas? Is it possible. I'm under a very strict deadline so I don't have too much time for experimentation. I understand that it is very easy to split the database, but is this then followed by a ton of coding?