Closing another database with VBA

[Gaetan]

Hi,

I’m having a problem with the code to do the following…

1- A user opens a file called Core.
2- Upon opening the splash screen (on the Form_Load event), it compares a
version number it finds within the database to one that is in another
database called Data.
3- If the versions are different, the Core file opens the Updater file.
4- The Updater file closes the Core file.
5- The Updater file copies the latest version of the Core file (located
somewhere else) and replaces the first one with the latest version.
6- The Updater opens the newly copied Core file.
7- The Updater closes itself.

I have no problem with point 1 through 3. Where I have a problem is I need
the Update to close the Core file. I know of CloseCurrentDatabase, but I
don’t want to close the current one (which is the Updater), but the Core file.

Anyone can help with this?

Thanks in advance.

 

[Stefan Hoffmann]

hi,

I have no problem with point 1 through 3. Where I have a problem is I need
the Update to close the Core file. I know of CloseCurrentDatabase, but I
don’t want to close the current one (which is the Updater), but the Core file.
Anyone can help with this?

Use any of the available frontend updaters (e.g.
http://www.granite.ab.ca/access/autofe.htm ) out there or write your own
as VBScript.


mfG
--> stefan <--