Hi Joel,

First of all, at SQL Server you don't use PACK instructions (you don't need it).
You can change data on SQL Server by just using an Transact-SQL instruction (insert into a SQLEXEC() instruction on VFP).
What takes 30 minutes to load? I did not understand!

Say something.

Ricardo




-------- Your message --------
I have a MS SQL 7 database and I need to change one table and delete many records.

Can I just use a remote view in Foxpro, edit the records and delete the ones I do not want??

Then do I need to PACK the SQL table????

How I can I load an SQL table without it taking 30 minutes to load??
I setup a remote view to the table, but when I open it, it locks my machine until all of the records load and that is at least 30 minutes.

THANKS
Joel
Houston, TX