if you are selescting from the table then use [with (nolock)] in Table hint to avoid making lock on the table

advantage: faster ... no locks

disadvantage: the data is not update...

what is your server amount of RAM ? bye the way MS SQL Server is a monster in dealing with RAM .. and if you give him more RAM .....

there are many another posible things you have to check :

1- you must set the bit datafiled to NOT Null .. and so give it a default value .. it...

try to debug this SP by doing this:

1- open query Analyzer ..

2- right click on your stored procedure .. and choose debug ...

(if a message appears tells you that...

what Version of access you use ? (Access 97, 2000 or 2002 [XP])

by the way Access 2002 [XP] is the best tool to upsize your application to SQL Server.

what about opening Control Panel >> Data source (ODBC) ...

and make a new DSN ... and choose SQL Server .. then in Server combo box .. you will find...

under your command prompet write (osql)

then you enter to your database

write

DBCC DBREINDEX

go

also search on microsoft.com for any other articles on MSDE and how to use Osql

by...

under your command prompet write (osql)

then you enter to your database

write

DBCC DBREINDEX

go

also search on microsoft.com for any other articles on MSDE and how to use Osql

by...

the best solution is to make a Stored procedurte on SQL Server ... then call it in Access by making a command and a Connection

making a Stored procedurte on SQL...

also in your Form you can make a connection and command variables and call your SP with them ... and this is the best way to use SP in Access...

to execute Stored procedure in Access make a new query .. and in type chose Specific >> (Pass through query) ... then write what you want as if you are...

for dreating stored procedure ... Create a new Access Data Page (ADP) and adjust connection on your server (from file >> connection) .. then new queries .. then Design stored...

try to remove the folder of SQL Server Trial Folder ... and trace in regestery too for it to remove it.

what about making a table with ID and result .... and in your stroed procedure: 1- delete all rows from table 2- insert All values into that table 3- select...

if you are using Access .. then use Access Security (Workgroup Admin) to make a file (filename.mdw) and adjust all users WorkGroup Admin to connect to this file ... another...