Out of curiosity, I tried to do the Database Optimization after Matty brought up this topic. Lucky for me that I had saved a copy since this process destroyed my project... something is definitely amiss with this function.
I looked at mine again to see what was happening during my attempt at optimization and here are two screenshots of the messages I received ("Error while naming file" and after about six more seconds I receive the next message is "Run-time error '6': Overflow") . The original file completely disappears??? I am using V10.5 Professional. The 'Database Status' indicates that I have no errors in the program.
If you store your databases in a sub folder of your My Documents folder, then there are Windows User Permission that come into play as well as security issues with a program being able to freely write to your User/LOCAL/Temp folder.
It's best that you totally avoid all of that by simply creating a folder at the root of your C or whatever drive you like.
For example, I use...
And inside this folder I have many folders, each on relating to the project or company I'm working for.
C:\My Software\Company Name\Invoice\invoice.bbd
Also, in a previous version of brilliant database, there were issues with naming files. I don't believe this has been fully fixed yet, although it has certainly been mostly fixed. To totally avoid a problem with the naming, never give a database a name of more than 8 letters, and always name it with a single word, not two words.
Your help, advice, and detailed explanations are invaluable!!! - I am certainly going to save that information for future use. The location of BD files and the naming convention I utilize change at this very moment.
I was telling my wife last evening about this issue with the Optimization that I had and your recommended solution. She looked at me very quizzically until I told her that it worked.
Besides the Brilliant Database product itself, James, you are the most valuable asset of Brilliant Database. I cannot thank you enough for all of your help.
Relatively new to the forum, but from what I've seen I must agree, James is THE man, and he is so willing to help us novices...greatly appreciated.
I have been using multi-word file names sometimes nested 2 to 3 folders deep in My Documents for a couple years without a problem optimizing. Recently upgraded to 10.54B and optimization seems OK. Have I been just lucky and should I change things at this point? Everything seems to be working OK.
I have been using multi-word file names sometimes nested 2 to 3 folders deep in My Documents for a couple years without a problem optimizing. Recently upgraded to 10.54B and optimization seems OK. Have I been just lucky and should I change things at this point?
The problem does not apply to any v9 or lower edition. It only applies to v10.
The initial v10 releases were a mess and the optimisation simply didn't work right at all, but with each v10 release this has gotten a lot better.
The current v10.54B is very good, however, you can still run into this problem if you are using your "my documents" folder and certain configurations of file names.
Everything seems to be working OK.
I think luck is on your side there more than anything else. The problem does still exsist as you can see from what Daryl has reported. It's simple to avoid the risk.