I close a database, but it appears that JET holds it open for a LONG time (from 5 to 100 seconds) after I close it. Therfore I cannot perform usual
file operations on it, (like delete it). Is there anyway to confirm when Jet
has released the file?
.
RE: Confirming close prior to other operation ..."mikeg" wrote: ... > I close a database, but it appears that JET holds it open for a LONG time ... > file operations on it, ... Is there anyway to confirm when Jet... (microsoft.public.data.oledb)
Re: Database Connectivity ... Never was Jet mentioned anywhere at anytime. ... >> Microsoft Access Database Solutions, with not a single mention of Jet. ... front end, and the underlying database engine, JET. ... like SQL Server, Sybase, MySQL, etc. ... (comp.lang.python)
Re: Do not want data to auto sort ... you are deluding yourself if you think viewing data in the Access ... > in for a shock here but Access is not a database.... The 'database' in question in usually Jet (it could be ... > then open a recordset write a the first portion of the data to a grid ... (microsoft.public.access.tablesdbdesign)
Re: Any reason why accessing Access should slowdown? ... On the MSACCESS / JET OLEDB front, you responded to a query I had about the ... Declared connection to Access database using string based on Jet OLDB ... Set up recordset filter in response to earlier input / selection ...¤ I am writing a VB6 App using an Access database backend ... (microsoft.public.vb.database)
Re: Explorer CPU Usage while accessing database ... Since Jet is a file-based database, the answer is: ... I suspect you are seeing the Jet delayed-write system in action. ... creates an idle period, during which Jet (and any other processes that are ... opening your connection before each insert and closing it immediately after ... (microsoft.public.scripting.vbscript)
