Working with a temporary database

G

Guest

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
backup of database with multiple backend data bases 5
Forms corrupting - so will create new FE - please tell me gotchas. 10
Temporary recordsets 3
Temporary tables and calling subroutines 3
MDE dabase convert error 3

Top