the JRO.JetEngine library from microsoft has a CompactDatabase method.

I have been using it for a long time - you just pass two connection strings to the method - source and...

This is more of a rhetorical question. The 249 limit obviously has to do with a smallint datatype. BUT I can't imagine why a normalized database would need that many...

Yes you can use the profiler to profile an Express Server but you can't use the output as a workload file for the Dtabase Tuning Advisor. The latter will not...

I have an application that has been running for over two years with MS Access. Its mdb file is about 70 MB (compacted) and the images that are associated with...

yeap! I have already implemented something like that so that users actually log out with out leaving their PCs connectedto the Access DB all night long...

I guess that common problems...

ok i think that was an easy one but I have another question: When we have an Access DB (not project) how can we forcefully disconnect the users that are...