Can't close an Access 2k ODBC connection

[Anon]

Hi,

I'm a bit of a PHP newbie. I've written a little script to dump articles into an Access 2000 database. The only problem is that the database grows large very quickly and I need to compact it, but I can't get the ODBC connection to close, with a .ldb file remaining open. This, of course, means I can't compact the database without rebooting the server.

Here's the code pertaining to this:

$conn_id = odbc_connect("articles", "", "");
odbc_do($conn_id, "INSERT INTO table_name([source], [category], [subcategory], [URL], [header], [Date])VALUES('$source', '$category', '$subcategory', '$url', '$header', '$date_today');");
odbc_close_all();

I've tried odbc_close() and odbc_close_all() but neither works.

Am I doing something stupidly wrong?

Many thanks in advance.

[Anon]

Send a query that fails (ie try to pull a field that doesn't exist). I don't know why this works, but it releases the lock and then you can run your compaction (an exclusive lock can be granted).

Works for me, your milage may vary!

[Anon]

Go to SErvices,
Stop PHP and then compact your database
The back to SErvices and start PHP again

You do not have to shut down the server

terry

[Anon]

Umm...that would be the best option, but I can't find PHP in the Services list. I've got it set up in IIS 4.0 as a scripting engine, but I can;t seem to stop that.

[Anon]

I think he means shut down IIS, which probably owns the lock on the database. This would probably work as well. But do give my "invalid query" method a try. This has worked for me with ODBC/Access databases with both PHP and Cold Fusion. Any query which returns and ODBC error should release the lock.

[Anon]

OK, thanks, I will give it a try. The database is holding up fine for the moment. I'll add a command to the script.

Thanks again!