How to create a small test db from a huge db.

L

Larou

I have a db that in total has 35million records. However, these have been
broken down into 5 different files. This still makes it very difficult for me
to make any progress on working with them.

I want to create a new, smaller db and fill it with a random selection of
records from one of the 5 huge db's first. Then crerate the Quries and Forms
that I can then run on the bigger ones.

Any help would be much appreciated.
 
D

David Cox

as I recall, no db to test on:-

I would import table structures into a new db then fill the tables with
append queries. I would select a random set of records from the master
tables using an expression
RND(ABS([yourkey])) < 0.001

selecting the constant to suit. .001 selects 1 in a 1000
The expression in RND() has to be positive and a variable.

The other Append queries have to select related records to preserve
integrity.

HTH and my memory is working.

I
 
Top