Access.LockFile.9 causing errors ]:o(

[Ladyborg]

I'm having an issue with a db created in Access 2000 which was working fine until a few days ago. Now I get an error on an asp page but if I wait 30 seconds to refresh it, then the information can be seen on the page.

I noticed when I opened the mdb on my pc that instead of creating an ldb file, it now creates an Access.LockFile.9 instead!!!!!

My admin looked at his logs and says when upload the files I send a folder permsions with it, all of the files and folders have AC atrributed to them which means Archive and Compress. The server does not assign the A (archive) so it has to be something else.

I posted this on the Access forum and was told if the IUSR has been moved to a write protected area it may not be able to make a temporary file for the database.

Sounds good, and I asked my Admin about it, but if so, it wouldn't also be happening on my own pc would it?

Any help would be greatly appreciated.
Ladyborg
"Many of life's failures are people who did not realize how close they were to success when they gave up." [Thomas A. Edison]

 

[mlawson]

Hi,

What operating system do you use? I have recently migrated over to W2k and have been experiencing longer 'lapse' times for ldb files to close, but haven't experienced a problem like you report.

Have a look at:

http://www.access-developers.co.uk

(discussion forum link), there are some pretty darn hot gurus in there that may help you.

M

"There are 3 kinds of people; those that can count and those that can't"

 

[Ladyborg]

I'm using Windows XP Pro. Ladyborg
"Many of life's failures are people who did not realize how close they were to success when they gave up." [Thomas A. Edison]