[dba-VS] Question on Windows and/or Access database closing, etc timing

[Charlotte Foust]

​Try checking for the existence of a lock table (.ldb or .lccdb) to see if
the system still thinks the file is in use.  Sometimes that lock file will
persist when it shouldn't, so you could try deleting it in code.  If the
delete succeeds, you should be able to copy the file.

​

Charlotte Foust
(916) 206-4336

On Sun, Apr 5, 2015 at 6:50 PM, Charles Wolfe <cawolfe at verizon.net> wrote:

> Hi All,
> The system I am working on uses MS Access as the data repository, which is
> related to part of the following.
> There is a problem of Windows, or VS run time, not closing and releasing
> an ACCESS file when a VS program says to close it in a timely manner so
> that the next effort to access the database from within VB says it does not
> exist or is in use by another user. Anyone found a good solution to this?
> Doing a dispose and finalize does not necessarily seem to work at speeding
> things up or freeing the database "quickly". I've had it take up to 20
> minutes on an XP system with VB2003!
>
>  Maybe related to the preceding: Has anyone had problems using VB to
> create a folder and copy a file or 2 to it, and then when trying to access
> the folder or one of the files from within the program found that Windows
> does not think it (they) exist? This seems to be a Windows timing problem
> but I'm not sure.  Eventually the folder and its content does appear; but
> it confuses the user to get a "does not exist" message within seconds of
> having the program create the folder, etc. The user creates a "project"
> data base, then tries to define a "sample" within the database (a single
> entry in one of the tables), it sometimes takes 2 tries to get the sample
> defined, the first time, the "database does not exist" 'error' happens.
>
> Charles WolfeSylmar, CA
>
>
>
> _______________________________________________
> dba-VS mailing list
> dba-VS at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vs
> http://www.databaseadvisors.com