Re: How to verify if Access database exists...
- From: Brian Bushay TeamB <BBushay@xxxxxxxxx>
- Date: Thu, 30 Mar 2006 21:47:39 -0600
I am using the ADOX components to create an Access Database...Check if the filename you are using for the database exists.
(TADOXCatalog.create1(path+file);
How can I verify if it already exists before creating it? Also, how can I
destroy it when I am done...
Here is what I need to do... When doing a mail merge with Word... I need to
create an Access DataBase with a table which will have different fields
depending of the circumstances... then, when the merge is finished, I need
to destroy this database... When I create the database, it creates a .ldb
(locking file) and when the merge is over, I can't delete this locking file
and I can't merge any else.
If there are no connections to the database you will be able to use file delete
code to delete the file
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.
- Follow-Ups:
- References:
- Prev by Date: Re: Removing Duplicates
- Next by Date: Re: Inserts so slow using _Connection.Execute
- Previous by thread: How to verify if Access database exists...
- Next by thread: Re: How to verify if Access database exists...
- Index(es):
Relevant Pages
|