Greetings All,

I have an application that has 2 main forms. The first is for data entry of a shoplifting apprehension. The 2nd is a suspect entry form, which can be called from the 1st form. The database resides in Sybase and I use ODBC to connect. The Control Sources of the fields on the forms are based on remote views.

The second form requires a social security number. If a SSN doesn't exist, the system goes out to a remote view, which is already opened, which contains bogus SSN's and increments the number by 1. Upon accessing this view, I issue and FLOCK('MYVIEW') to lock the table. This bogus table is also used in another application(Powerbuilder). After my update, I issue an UNLOCK IN MYVIEW. Apparently, I'm not doing something right because my app tends to lock the other application up when they try to access this table. The user has to then exit the application to free everyone else up. I had placed CURSORSETPROP('buffering',5,'myview') in the init event of the form and even tried physically closing the table upon exit of the form, but they still get locked.

Any ideas?

Thanks in Advance.

Scott