Using the CreateFile and GetFileTime API's

[VB6Coder]

I've always used the CreateFile API to get a file handle, which I can then pass into the GetFileTime API to get the file times. This works fine until I tried to get a file handle to a Microsoft Access Database file which was open in Access.

Is there another way of getting a file handle that won't fail if the file is locked?

[jim mcnamara]

Go to VBNET
Search for "file api"

Take a look at this code:
Obtaining and Changing a File's Created, Accessed and Modified Dates
This uses a different suite of api's.

[VB6Coder]

The VBNet example uses the OpenFile API, so I'll give that ago.


Cheers

[Nucleus]

I think it depends on how the access database was opened. If opened for exclusive use, I don't think you will be able to get a handle.

In all other situations you should be able to get a handle using create file api.

[VB6Coder]

I wasn't opening the Access database exclusive, and for some reason the CreateFile API kept returning me 0.

I've now changed my code to use the OpenFile API instead of the CreateFile API and that has fixed the problem.


Cheers Guys