Error messages in Base files

Discuss the database features

Re: Error messages in Base files

Postby DACM » Tue Dec 10, 2013 12:31 am

arfgh wrote:...i have tried to inverse the way to embed again the files, and for some reason i cant edit the database files....

why ?

OPTION A: You know the many benefits of a split-database architecture including data-safety, upgradability, front-end options, concurrency, etc. And while not inherently portable, a Base front-end file (.odb) may be macro-enhanced to provide sufficient portability, such as when adopting a portable Base template.

OPTION B: You know that an embedded-file database has an advantage or two, such as inherent portability and ease of modifying existing field-attributes using the Base GUI. But you also know that Base is buggy and incapable of reliably hosting database files embedded within the .odb container file -- leading to rampant data-corruption, among other drawbacks of the proprietary design.

Weighing the options, you chose to convert to a split-database architecture. This is common and recommended.

Now you're realizing that modification of an existing field attribute with a split architecture involves selecting an SQL command -- perhaps among those provided by F3K Total and Villeroy above -- and typing it into the Tools > SQL console in Base. This not only requires 60 seconds of effort, but it's understandably uncomfortable because SQL is an unfamiliar language. Knowing that SQL is easily generated by a GUI, and that you may encounter an additional episode or two involving modification of existing field-attributes, you seek GUI relief. But then, it's not worth 100 bucks simply to avoid these rare instances of pain. After all, that's $100 simply to avoid a few minutes of discomfort over the life of the database -- not to mention the setup required to connect another front-end to your database.

So you're concluding that it would be better to revert back to an embedded-file database. I'm sorry but I don't think you'll find many folks here willing to spend the time to outline the steps or perform the procedure simply to alleviate those rare minutes of pain in this case. :(
AOO 4.1.x; LO 4.2.x; Windows 7/8 64-bit
Warning: Avoid embedded databases --> Solution: Adopt a portable 'split database' folder
Soli Deo gloria
User avatar
Posts: 1138
Joined: Tue Nov 03, 2009 7:24 am

Re: Error messages in Base files

Postby arfgh » Thu Dec 12, 2013 8:45 pm

yes, revert back in order to use the base gui to edit the database fields. Then with your tool i can split it again.
I need to be able to edit the database fields types, etc.
OpenOffice last version | Mageia Linux x64 | Windows 8.1 Enterprise x64 | Windows XP Pro x64 SP2 | Java 1.8.0_231
Posts: 531
Joined: Tue Mar 05, 2013 6:44 pm


Return to Base

Who is online

Users browsing this forum: No registered users and 6 guests