Search results

This code worked beautifully but has suddenly stopped working, with the second database now refusing to copy the first because the fist has not closed properly - there is still a ".ldb" file open for the first. It does not seem to reach the DoCMd.Quit line properly. I can't see why it has...

Does anyone know how I might get the second database (the one that performs the "FileCopy" to make a backup of the first) to close and save the first. I'm wondering whether that might work? Thanks

As far as I'm aware it's debugged - it worked fine before. I'm not sure how to compile it - can you clarify this? When I click on the debug option it picks out the first "FileCopy" line in the below code, which is in the second database whose only purpose is to copy the first. The permission...

The below piece of code, which backs up the database which is currently open by opening another database, has suddenly stopped working in Access 2000 - it gives a "permission denied" error and the option to debug the code. The Visual Basic editor indicates that it is the line which copies the...

Here is the code in full cut from the relevant 'Option Compare Database' for anyone who is a novice like me. I've added the "appAcc.RunCommand acCmdAppMaximize" to make the new Access window maximise: Function OpenNewDatabase(strDatabase As String) Dim appAcc As Access.Application...

OK, I think I have it working following a bit of guesswork and remembering how this type of code works. I pasted the code you referenced into the editor, and then wrote: Private Sub Command11_Click() If MsgBox("DO YOU WANT TO BACK UP THE DATABASE?", vbYesNo) = vbYes Then OpenNewDatabase...

Thanks for that reply - from the following question you will probably see that I really am blundering around! How do I use the above instead of the relevant lines in the below code - for example where/how do I define the path to the other database and then run the Function: Private Sub...

I'm trying to open another database and close the original by clicking on a button on a form (the second database will then backup the first). I'm very much an MVB novice and am blundering around a bit, but I've almost got it working using a Call Shell command. Only the path I am using for the...