Data Management Strategy ???

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob Segrest - 03 Oct 2003 13:33 GMT

I have written an Access application to manage an inventory. I have split
the data into a separate file and would like to retrieve and store it in
another location at each time my application is run.

Is there a way to execute code in Access before the data file is locked?

Is there a way to execute code in Access after the data file is released?

An alternate method would be to create a VB application, have it manipulate
the data file and then launch Access. This is fairly easy using a GetObject
call. But I would need for the VB application to wait for Access to finish
and then do a few more things. I'm not sure how to do this... Any ideas?

Any pointers would be greatly appreciated.

Bob Segrest

Reply to this Message

Douglas J. Steele - 03 Oct 2003 22:39 GMT

As long as you haven't actually opened any connections to the back-end
(i.e.: no queries open, no bound forms open, etc.), you should be able to
copy the back-end with no problems. Just check whether or not the locking
(.ldb) file exists. If not, you should be safe.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele

> I have written an Access application to manage an inventory. I have split
> the data into a separate file and would like to retrieve and store it in
[quoted text clipped - 12 lines]
>
> Bob Segrest

Reply to this Message