DataTables + AJAX source + MS Access

online

Hi,

I'm using DataTables + AJAX source + MS Access and it's working great!

However, I faced a problem where the system will auto-generate a ??.ldb file due to access to the database.

I totally understand the purpose, but even after I close the DB connection and set to "nothing", the file still exists and it doesn't allow me to manually overwrite the database file, which I often required to do so.

[code]
...
$(document).ready(function() {
var oTable = $('#table_id').dataTable( {
"sPaginationType": "full_numbers",
"bAutoWidth": false,
"bProcessing": true,
"bServerSide": true,
"sAjaxSource": "db_select.asp"
...
[/code]

allan

This sounds like it more of an MS Access / ASP question I'm afraid. I know absolutely nothing about these two platforms (haven't even heard of a lab file before!), so I'm not able to offer any help. I'd suggest asking in an ASP forum.

Regards,
Allan

online

Yep, thanks, will try your suggestion.