Ed,

Thanks for your help. I wish I knew more about app development. I can usually get my task done but I am afraid not in the most effective manner. I would like to tell you a little about my app and maybe you could give me some pointers. I work in an Engineering Department where we build aircraft seats. My task was two fold, to make our Engineering Drawing signoff process electronic and to make the drawings viewable to our shop on a common PC. We use several different drafting applications and could not afford for everone in the signoff cycle to have each app needed to view the drawings. I have managed to come up with a way to convert the drawing to PDF format and my app finds the PDF file and uses API to pull up acrobat with specific drawing. My app is located on a network that about 90 users have access to. On an average there are 25 users logged on at any one time. Most of my tables have indexes on them that I created in the table designer. I use these indexes for the Seek() function throughout my app. When my app first starts(a user logs on) a maximized main form that loads all the tables of the database into the dataenvironment appears. Another form that represents a main menu appears in the center of the main form. I have a program that will run if it is the first logon and no other instance on the app is using any of the tables. It will open each table and pack any deleted records.

Now to my troubles. I was using an indexed table the other day. I was using a form button to seek for a particular record. It said the record was found and added info to the record. then I tried to pull up the record with a subsequent operation and bogus data was displayed(anothe records info). I went into the table and the record that was supposed to exist was not there. The info that was appended was appended to the wrong record. After getting evereyone off the database I did a reindex on the table and it fixed it.

Second issue. I have a form that shows the status of a drawing. The info shown here comes from two sources. A table in the database itself and data from an AS400 table that I access through SPT. Only certian users have the ability to edit any info on this form but all can view it. My problem is that those who can do updates experiance alot of hangups. When the ESC button is pressed If says record in use by another user even though the record is only being used by one user.

Thanks for any help Ed.