Working with a temporary database

D

Dale Fye

I have an application, in which I would like to create a couple of temporary
table. Marshall mentioned that I would be better off If I created a
temporary mdb file to put these temp tables in, thereby avoiding bloat and
the need to compact my front end (really good idea).

My Access Help has become corrupted, and I am unable to find any help on the
CreateDatabase method, to create this temporary mdb, if it doesn't already
exist. If it does already exist, I need to know how to delete selected
tables from the mdb.

Any help would be greatly appreciated.

Thanks
 
M

Michel Walsh

Hi,



DBEngine.CreateDatabase "C:\toto.mdb",dbLangGeneral



Hoping it may help,
Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Having trouble with temp table 1
Having trouble with temp table 2
temp db 1
Vertical short line in front of word 0
Create new sheet based on cell value 1
Cbo box Limit to list = No write question 2
Temporary recordsets 3
Regarding Compact & Repair Database 3

Top