?
Solved

indexing database

Posted on 1998-07-26
3
Medium Priority
?
147 Views
Last Modified: 2010-05-03
I am having difficulty appending records to the end of a database.  I understand how AddNew works but it sometimes puts records in between other records instead of at the index.  I even have a primary key that I created.  This primary key is of integer type and I increment it when I add a new record.  When it reaches 10, it appends that after index 1, not after index 9.  How do I overcome this?  I need to append each new record at the very end.
0
Comment
Question by:timpeters
  • 2
3 Comments
 
LVL 2

Expert Comment

by:percosolator
ID: 1466760
What are you using to view the data with?

Does it view like

1, 10, 11, 12, 2, 3, 4, 5, 6, 7, 8, 9?

0
 
LVL 2

Expert Comment

by:percosolator
ID: 1466761
Also, what type of database are you accessing?
0
 
LVL 1

Accepted Solution

by:
web_crusher earned 150 total points
ID: 1466762
the database is fine - you just view it with the wrong viewer

the data1.recordser.movelast - always go to the last record
and put there ,after the addnew, your record
you view it with a bad viewer
and buy the way - a key that based on an interger is very limited - try the auto if u use that kind of db or just arrange a function that add some character to one of your fields - a one that will be original and dont have couple of those - cause then u wont have a key!!!

open a datagrid - u'll c it fine!
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Suggested Courses
Course of the Month8 days, 21 hours left to enroll

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question