Create Temp Database

[dbay]

I need to create a temp database alongside the front end to put all my temperary tables in. I have serious boating issues in the front end do to how my search form works and this can not realy be changes. I need some realy good examples on how to create the temp database, link to it, and delete it when I close the front end.

 

[JANR]

See this page for some coding examples: http://allenbrowne.com/func-DAO.html

JR

 

[Galaxiom]

An easy alternative is to keep an empty database and simply copy it to the temporary location as required then delete the copy when you are finished. It can be kept linked even when it doesn't exist because it will only error when you try to open the linked table.

It isn't as elegant as making one since you need to keep it as a separate file.

 

[dbay]

Thanks for the info from both of you above. I will see what I can do.