SOLVED how to enlarge a database?

[STEVENSMITH100]

I have just gotten a request for which my db is not prepared. It is now too small.

What is the save way to a larger db?

Do I build a new db and move the old data with cvs files?

Steven

[dacm]

Databases can, for all intents and purposes, grow ad infinitum. So could you give us some details such as your database type (flat-file 'text' tables or relational database)? Or otherwise give us some details that have led you to the conclusion that your database is "too small." Do you mean to say that your database type/engine is too limited in terms of built-in features or SQL functions?
_________________
Soli Deo gloria
Tutorial: avoiding data loss with Base + Migrating 'Embedded databases'

[STEVENSMITH100]

Hello Helpers:

Just so you will know that I am not a complete nut, from '73 to '91 I was a senior programmer. At that time I knew a lot about my field. It has changed..... I got out before PC's or databases files. So I am in a small boat in a vast sea of ignorance, with a long learning curve and a short paddle.

My database file is a “flat-file”. Records are 400 bites long, all fields are char. The file has 250 records, and is a “name/address/birth date/etc. File.

It is my understanding I can't add fields to the end of a record, but this new project request used up my “JIC” (just in case) space. So my problem.

I need to add 12 new fields and some more JIC space

Steven

[dacm]

I'm sorry but it's still unclear if you're connecting to a CSV file, dBase folder, or SQL database engine.

What do you see in your status bar at the bottom of Base...?


_________________
Soli Deo gloria
Tutorial: avoiding data loss with Base + Migrating 'Embedded databases'

[STEVENSMITH100]

It seems I have an "embedded database" and HSQL database engine.

And now I have learned ONE more thing, the list is getting shorter.

Thank You For Your Help

Steven

[dacm]