Hi - I just wanna check that I am not making some wrong assumptions about shared access - I am using VB and VFP together...

When I open forms I use a readonly recordset...

rsGetName.Open strSQL, DB, adOpenStatic, adLockReadOnly, adCmdText

If the user decides to make changes and hits the save - I store the primary and the close this rs - I the open with this...

rsGetName.Open strSQL, DB, adOpenStatic, adLockOptimistic, adCmdText

I rs.find the primary and then update the rs and then close - then open the readonly rs again finding the primary again so it stays on the same record...

1. Is this OK in a shared access environment?
2. Are there better ways of handling this?

PS. So so many questions - it's just it's my first venture with VB and I there's a lot I need to learn but not a lot of time to learn it in!!!