I did the recommended 3.7 upgrade, but now can't get the program to open. I don't know why I ever thought that this would go easily! Error message is:

Error in UpgradeForTripReports!

The Microsoft Jet database engine cannot open the file 'C:\Birder'sDiary\upgrade.mdb'. It is already opened exclusively by another user, or you need permission to view its data. - 3051.

Please help!

Very sorry for this. Interesting error. It indicates that somehow the file 'upgrade.mdb' has been left in an open state as the operating system sees it.

Do you have this file open by any chance with MSaccess or some other tool?

Is BD running in another window somewhere?

In either case, a simple reboot of your computer should quickly solve this as it forces the OS to flush its cache of open files and no file should be already open when you reboot.

I have never seen this error before, ever, in thousands of installations. So, not to worry, just a weird quirk in Windows.

Let us know please after you reboot.

Jeff

I did a restart and a complete shutdown and reboot. No change.

That is certainly strange. Can I get onto your system please and get this fixed for you?

Go to the Support >> Desktop Sharing page on this site. Read the instructions and click on the Start Session button.

Thanks,

Jeff

Very strange behavior. Spencer is the only one reporting this issue.

I got onto Spencer's system and found that if I run BD "as Administrator" we no longer get this error; the database gets updated; and you can now run BD normally on subsequent attempts because it no longer needs to update the database.

I suspect that when the next release is made, Spencer will again get this error, and again have to "run as admin" to get around this for the first time.

I have no idea what could cause Windows (as this is an error from Windows) to report this error when run without admin rights, but have no problem opening the file now that the program has admin rights.

But - I believe it just might have something to do with an Access Security File being present on Spencer's system. I don't quite understand the purpose of this file, but it is not present by default.

Spencer, when you have the time, please search your entire C: drive for System.mdw. Let us know if you find it.

Thanks,

Jeff

Here is a Microsoft Knowledge base article on this file. For future reference.

Jeff

I am quite certain that I did NOT say I understood it.

ha ha ha

Jeff

I just ran into customer #2 with this problem out of hundreds.

It appears to be a privilege issue. Wherein, "run as admin" fixes it. Then you no longer have to run as admin, because the 'upgrade.mdb' is not opened unless you have updated BD.

I found an issue online that 3051 may have to do with an corrupt DB. So on this customer's system I did an "Access repair and compact' on upgrade.mdb. And then ran BD normally. The 3051 went away, but now I get "RTE 70; permission denied".

This new customer, as well as the one above, does not have admin privilege in the account they are running or perhaps it is that they have UAC running. Not sure as this customer had to go and I did not have more time to debug.

If we encounter this again, we may want to test the file privs on this file.

Also, this new customer did NOT have a system.mdw file on his system. I do, and I don't have the problem. So I no longer believe this is linked to the problem.

fyi

Jeff