Adding new Record into existing DB.

[Denzil Hathway]

I tried this inquiry a while ago but didn't understand the only answer I
got. It was far too complex for me. How can I insert a new record into the
middle of a large pre-existing Access database of thousands of records?

Neither my wife nor I understand Access very well. She has over many years
built a complex media database including thousands of classical CD's, DVD's,
VHS, Beta, LD etc., separated into and designated by the actual media.
Designated Fields include Title, Composer, Artists, Conductor, Orchestra,
Language etc, etc. - many, many fields. These media are filed in two
separate locations.

With the complex nature of the differing media and the many countries of
origin involved it is well nigh impossible to be consistent. Take Opera for
instance. Fields include Composer, Librettist, Title, Place of Performance,
Artists - at least five to a Title, Language, Orchestra, Conductor, Location
and file number of recording ... and so on.

To allow for exceptions Michelle has chosen not to designate a key. She
built the database leaving many spaces to add new items. Now, fifteen years
later, those spaces have been filled in. How does she insert a new record
into a pre-existing list of records?

She has been manipulating some by using Paste Append but that is cumbersome.
There must be a way to slip a new record in between the others without going
through complex maneuvering. Anyone know how? Can anyone help? At least two
of us would be grateful. Thanks, Denzil.

 

[Dai Wei]

How can I insert a new record into the middle of a large pre-existing Access database of thousands of records?
I guess that it's impossible, but you can try to maintain a sort flag
column according to your wish. Then use OrderByOn properity on that
column.

 

[Al Camp]

Denzil Hathway wrote:
How does she insert a new record

into a pre-existing list of records?

I think there's a conceptual problem here.
Database records occupy their position in a table due
to the information they contain, and how the records are sorted.

If the data were sorted by composer, Bizet would not be
able to be "placed" in the center of your records. You can enter a
new record into a table at any time, but where it ends up is totally
dependent on how the data is sorted.
hth
Al Camp