How do I make my access db into a multiuser on a server?

I been trying to split my database on a SQL Server but its almost impossible to split and make that multiuser. Other thing it is possible for a multiuser use the database in access without having the program on their computers just connecting to the server?This forum is for IBM's DB2 database only. Try the SQL Server forum.

How do I know what action triggered a trigger...

Hello

If I have a trigger for INSERT and DELETE, how do I know what action was executed ??
I prefer not to split the trigger to one for each action, because the the procedure for both is almost the same.

Another question, How can I know what records were updated? I need to concatenate the ID/ID's to the SQL in the procedure.

Thanks,

Inon.If (EXISTS(SELECT * FROM INSERTED))
Trigger for INSERT
If (EXISTS(SELECT * FROM DELETED))
Trigger for DELETE

go thru BOL for more information about INSERTED,DELETED tables|||If (EXISTS(SELECT * FROM INSERTED))
Trigger for INSERT
If (EXISTS(SELECT * FROM DELETED))
Trigger for DELETE

go thru BOL for more information about INSERTED,DELETED tables

Ok Thanks,
But tell me, isn't it a bit spendy on resources ?

Inon.