Thanks for the posts guys. I started out using SS2000 then my network admin switched me over to SS2005 because he was having problems with SS2000 for some reason. So...

I see the point you were making more clearly here. I didn't think it would work but i don't know anything about networking and the network admin is going to...

Sorry, I looked for quite awhile. I guess i didn't look good. I was looking at all the bold text but ignored the small text.

I tried to do a search...

This may be caused by the fact that I used my laptop not apart of the network to access the server. I did this because of difficulties using my work...

Do i need all of this code and how do i implement it into my code above?

Sample code from BOL

DECLARE @cookie varbinary(8000);

EXEC sp_setapprole 'Sales11', 'fdsd896#gfdbfdkjgh700mM'

, @fCreateCookie...

I'm using SS2005 and VB6. No store procedures yet. I created the approle but i still have not placed all the necessary information in my app to connect to the...

I'm using VB6 with ADO.

Thanks guys that is extremely helpful. So what are the alternatives to application roles? I'm thinking that app roles are still the way to go assuming i don't have problems...

Jane thanks for the reply! It was really good. It was exactly what the article above said. It did offer a HINT at a solution but didn't really go...

I didn't understand the ramifications of what you said. Please explain.

HanShi

Here is my connection string in VB6

connString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=FAE;Data Source=Keoki"

adoConnection.Open connString

Jan Van der Eecken

Thanks for the article. I've read it. I feel it left me hanging...

Thanks for the explanation. The new one is the production one. The old one is a test database. The changes are not super significant. I have a script that i...

I'm sorry I'm not familar with the term "promoting."

I updated the new database structure slightly and didn't want to go back and figure out how to modify the existing one. It would probaby have been the best way...

The best i can find is how to Import and Export information from Access to SS2000. Is this the same technique?

http://support.microsoft.com/kb/285829