this one is really bugging me and has been for days im using a connection string :

PROVIDER=SQLOLEDB;DATA SOURCE=LOCALHOST;UID=test;PWD=test;DATABASE=test

yet when i run my page i get

SELECT permission denied on object 'Table1', database 'test', owner 'dbo'.

yet for the user test i have checked all the select, insert, delete etc. boxes

anyone any idea on this ?

Looks an error with the userrights. Did you try to delete all user rights and then test the connection?

And are you sure you use the SQLOLEDB data provider for this set up? And what happens if you test the connection within dreamweaver?

<hr><b>DMXZone support manager</b><br><a href="www.kousman.nl">Kousman web resellers</a>