Hi - I've been using BD Ultimate for some time with no problems, however, one of my database used in a business situation has an error message of "Too Large String: 12234455 etc".
The database will not open at all and Brilliant Database can only be be closed via the task manager.

Any ideas how this can be put right or how I can get into the file?

Many thanks
Paul

If you cannot open the database at all, I'm afraid there is nothing you can really do to repair it then. It's most important to be at lease be able to open it to run the maintenance repair on it.

All I can say is that I hope you implemented a backup system within the database itself or the normal server backups are an option for you to revert to.

If you didn't have you really need this restored, you could consider sending it back to brilliant database. They will for a charge repair it. Providing you can get them to answer your email.

Regards
James

Me again.....
Are you 100% sure you don't have your database set to create a backup of itself when opened ?

If you do, and it crashed, there will be perfectly working copy of it in the same path where you where running the database from. It will have a ~1 on the end of it or some other number depending on how many times it crashed.

Beyond that, I cannot think of anything other than going to the server backup. Surly there's one there.

I used to have this type of problem earlier. When I analysed it has happened when you store more number of attachments in the database records.Also when synchronize two database by forms and queries particularly the relational one. If the database you are importing is clean and simple you do not get issues.
Eventhough the error comes keep pressing the enter button sometimes it opens with some limitations but that is enough to repair the database or bring your valuable records.
Also when you design a database follow a correct convention in naming forms and vaiables.
Be sure atleast once in a week optimize the database.