>>>>>In my cleanup method I call CLOSE ALL. When I do that I get an Update Conflict error. How do I find out which table is causeing this problem so I can fix it?
>>>>
>>>>Are you using a view? If yes, make sure you don't have any primary key conflict.
>>>
>>>Yes, I'm using a couple of views. How do I check for a Primary key conflict?
>>
>>I would suggest to open the table manually and do a SQL group by to see if you have a key which has more than one occurence.
>
>Mike,
>
>I've tried that and everything seems OK. The error doesn't happen everytime I quit the program, so it is hard to catch.
>
>Ed
Instead CLOSE ALL, you could close table/views one by one with appropriate error trapping for each USE command. At least here you will catch the alias.
Edward Pikman
Independent Consultant