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

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
How do I check if there are no connections to the database? And I would I
delete the connections to the database? I've tried to do a if FileExists()
then DeleteFile... but it does not work... it does not give any error, but
it does not delete either.

H. Dumas


"Brian Bushay TeamB" <BBushay@xxxxxxxxx> a écrit dans le message de
news:349p225knmqd9ucg8tmudkovmre954usds@xxxxxxxxxx

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

  • Re: How can I open an SQL database and be the only one who has access to it?
    ... you can determine how SS permits access to your server. ... SINGLE_USER allows one user at a time to connect to the database. ... controlled by the termination clause of the ALTER DATABASE statement. ... To allow multiple connections, the database must be changed to ...
    (microsoft.public.data.ado)
  • Re: ORA-12518, 04030 errors after 9i-10G upgrade.
    ... All went ok until users started connecting in 100+ numbers, database is ... set up for dedicated server connections, this was never a problem in 9i. ... This did not solve problems so bounced database and decreased SGA to ... out of process memory errors. ...
    (comp.databases.oracle.server)
  • Re: ORA-12518, 04030 errors after 9i-10G upgrade.
    ... All went ok until users started connecting in 100+ numbers, database is ... set up for dedicated server connections, this was never a problem in 9i. ... out of process memory errors. ... that Oracle is having issues with OS resources. ...
    (comp.databases.oracle.server)
  • Re: ORA-12518, 04030 errors after 9i-10G upgrade.
    ... New server has 6GB ram. ... All went ok until users started connecting in 100+ numbers, database is ... set up for dedicated server connections, this was never a problem in 9i. ... This did not solve problems so bounced database and decreased SGA to ...
    (comp.databases.oracle.server)
  • Re: How to handle large number of users
    ... The client app will work on mobile phones using WinCE and it is just a small app updating some tables in the database on the server. ... use a Database Pooling mechanism, that controlled the number of active connections to the DB server through the pool. ... You are not going to be storing mountains of data, the streams will be small and the data capture should be relatively small (unless you are collecting transaction times, rates, etc). ... Lets assume that your transaction rate for inserting and/or updating the database for the 10K data stream is 100 milliseconds. ...
    (borland.public.delphi.non-technical)