.."eg. local tables or queries that use local tables only.  "..

By Local tables you are refering to those tables in the MS Access MDB.

I found this link..

http://www.developer.com/tech/article.php/10923_721441_3

So I guess I do this..

1) Use NT Windows trusted security

2) Turn guest account off, by deleting it.

3) Create a accounts/groups for my USERS, with asscociated...

Thanks, excellent posts. I have a clear understanding now !

Thanks. had to be that simple

I also came accross this code ,,,

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=768&lngWId=5

    --     

    -- Name:...

May be so, I was just wondering if one can do this ??

If so how ?

My Language Setting on SQL server is English

Frank, So what you are saying is this, please correct me if I am wrong

Currently, I have set up my date fields as...

I answer my own question.

My access FE is MDB.

Yes a pass thru query can easily be turn into a cross tab query at the MDB client end.

Just need to run...

This means users are not connecting, I use MDB and ADO so I can check that a connection is made and send a error message when it is not.

Network, maybe...

This is my conclusion, yes one can make filegroups read only. But its best to transfer data for users ODBC to a READ ONLY database. Then access to tables is...

I see that a table can be placed in a USER file group. And the file group can be made read only in the same database.

Say primary is the READ...

"i have never seen anyway to hide non-user sprocs except in EM."

How do you do this,then ???

After more readings I found that SQL server returns positive error numbers, so if I use negative numbers, then I can confirm that the error number is of my creation as a...

I think I am sorted with this now anyway.

Advice is

- Keep transaction very short

- Return server to default isolation level READ COMMITTED when on and on error found.

- Consider using...

So this code would be, is this correct

EXEC @rc = ONE ‘Green’

SET @ErrNo = @rc

March 29, 2005 at 4:32 pm