Re: How to verify if Access database exists...




I am using the ADOX components to create an Access Database...
(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.
Check if the filename you are using for the database exists.
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
.



Relevant Pages

  • How to verify if Access database exists...
    ... How can I verify if it already exists before creating it? ... destroy it when I am done... ... to destroy this database... ... and when the merge is over, I can't delete this locking file ...
    (borland.public.delphi.database.ado)
  • Re: getting rid of the "Issuing rollback()" warning
    ... When a DBI database handle is destroyed, ... The DESTROY method naturally disconnects the database connection. ... including Oracle, will commit. ...
    (perl.dbi.users)
  • Re: slightly off topic - "break" a database
    ... >What you did was not funny. ... much less a friend. ... A database snapshot even on someone's laptop could be for a power ... She could also have used it to gather data or destroy ...
    (comp.databases.oracle.server)
  • RE: Semantics of InactiveDestroy
    ... "InactiveDestroy" attribute on DB handles. ... used to disable the *database engine* related effect of DESTROYing ... in the DESTROY method'. ... shown in the trace log whenever a DBI or handle tracemethod ...
    (perl.dbi.users)
  • Re: Null out the current object... possible?
    ... My specific case is my object is a CustomProperty. ... it removes it's record form the database and I wanted to destroy the ...
    (microsoft.public.dotnet.languages.csharp)