I think you have to look how to make Path-through query in Access (so you make it on SQL Server directly)

and in this path through query you can write (with...

I think there is a script here in sqlservercentral.com that help u to kill all of the runnung processes .. so you can remove the DB .. search for that...

When you use complicated queries joined from several tables, These tables are updated frequently, then you lock these tables (or you will wait for previous transaction lock on these tables...

the best solution for transfer data and Structure from SQL Server to Access is:

open Access

from "file" menu, choose "Get External Data" , then "Import"

then in "Files of...

I download many Tools that may help me in writing and developing stroed procedure and views ..

the best tool I found is "msSQLed" .. it is very good

I hope...

thanks everybody

I use sp_executesql and if any error happens ..the @@error varialble will hold it.

I also take in my mind that any variable you will use in sp_executesql it...

also take care that Cascade Delete is very dangerous (in depth)... because you may delete a row in a table and discover that there are many rows in many tables...

I think if you use a programming language (or access) and link the form to the Table fields ... then you don't have to write N' ...

try to have the Local administrator of the machine .. and adjust SQL Server to run on that Local account

on server

1- open Enterprise Manager .. righe click on your server and choose properties

2- on connections tab , write the maximum conncurrnt user connectios

on Database .. i don't know if...

I think you have to check @@error global variable after any inser, update or delete ..

and

if (@@error 0) /* then error happened */

...

also you can put it on a job

Have you thought about running a trace against the server to capture the textdata information (that is related to deadlock only) and save this trace into Table

and then...

here is another link for "Microsoft Office Web Components"

http://download.microsoft.com/download/c/2/8/c28831e9-684e-4aab-9af3-f061bf68ad70/WebCmpnt.doc

I hope it help u all

I think the best thing is "Microsoft Office Web Components"

you can use this component in Any Office product or in any programming langusge (like C#)

see this 2 links

http://www.sla.urc.ac.ru/edu/chMath/intro2003/interest/owc/owc.htm

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacbk02/html/odc_4010c12.asp

I hope...