Home > Archive > Clarion > February 2006 > Access database - file is opened until aplication is closed
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Access database - file is opened until aplication is closed
|
|
| Gallinarius 2006-02-10, 6:55 pm |
| Hi,
I have Clarion 5.5 and I'm using ODBC to open Access database. I need to
delete .mdb file after I read data from it, but I can't because file is
opened until I exit aplication.
I tried close this file using Close(filename.mdb), but nothing changed.
Is there any solution for this problem?
| |
| Jean Lussier 2006-02-10, 6:55 pm |
| After your last CLOSE(filename), put this code:
filename{PROP:Disconnect}
You can use any "filename" that was previously opened.
You need to do this only once - no need to do it for
all tables that you had opened.
This is in the documentation and help file, under
"Database Drivers" -> "SQL Accelerator Drivers" -> "SQL Driver Properties"
You will find a lot of good info there....
Jean Lussier
INFORMACCES - Montreal (Canada)
"Gallinarius" <gallinarius@hotmail.com> wrote in message
news:dsi287$2n0$1@ss405.t-com.hr...
> Hi,
>
> I have Clarion 5.5 and I'm using ODBC to open Access database. I need to
> delete .mdb file after I read data from it, but I can't because file is
> opened until I exit aplication.
>
> I tried close this file using Close(filename.mdb), but nothing changed.
>
> Is there any solution for this problem?
>
>
| |
| Gallinarius 2006-02-11, 3:55 am |
| Thank you very much for help!
"Jean Lussier" <jean.lussier@nospam.com> wrote in message
news:UF0Hf.13223$1U6.200688@weber.videotron.net...
> After your last CLOSE(filename), put this code:
>
> filename{PROP:Disconnect}
>
> You can use any "filename" that was previously opened.
> You need to do this only once - no need to do it for
> all tables that you had opened.
>
> This is in the documentation and help file, under
> "Database Drivers" -> "SQL Accelerator Drivers" -> "SQL Driver Properties"
> You will find a lot of good info there....
>
>
> Jean Lussier
> INFORMACCES - Montreal (Canada)
|
|
|
|
|