I have moved a Project file (adp) and two database files from the SQL V7 
server (ldf and mdf) to another server and the Stored Procedures I have 
created appear to be missing from the copy. The forms, tables etc work 
fine apart from those that use stored procedures to select records.

Where are they stored and how do you move them between the design 
environment and the users system please?

Have you checked permissions on the stored procedures? Also, how did 
you 'move' the SQL files? I've used sp_detach & sp_attach and had no 
problem with this method (esp. good for different SQL configurations). 
Also i keep a text library with all my sp code so i can copy and paste in 
these situations.
HTH,
Jim Tredinnick

> I have moved a Project file (adp) and two database files from the SQL V7 
s> erver (ldf and mdf) to another server and the Stored Procedures I have 
c> reated appear to be missing from the copy. The forms, tables etc work 
f> ine apart from those that use stored procedures to select records.

> Where are they stored and how do you move them between the design 
e> nvironment and the users system please?