asked on

temporary files in access 2010

Hi,

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?

Thank you
AEN

ASKER CERTIFIED SOLUTION

Rey Obrero (Capricorn1)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

peter57r

It is extremely unlikely (not impossible but really unlikely) that you have used a command that will not work when you split. So no coding changes would be necessary.

Split the database using the tool, delete the link tabnle for the temp table and then import the 'temporary' table back into the front-end.

SOLUTION

Jim Dettman (EE MVE)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Scott McDaniel (EE MVE )

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Dale Fye

Thanks for the plug Scott! ;-)

Jim Dettman (EE MVE)

I have to go back and review all the avilable articles...I don't remember seeing that one come through.

EE really needs to find a better way to leverage these articles.

Jim.

allfredeneuman

ASKER

Thank you all for your help. I have split the database and kept the temp tables in the front end. Everything is working great!!!!

AEN