thank you! i understand now.. also for each login i need to give them access to every table in sq server, correct? select, update,delete.....,  how come right now all my user's have...

wow Thank you!!! this will be a view correct?

sorry... basically this query is coming from another one (i did not create it) .. the one i posted before was the one i have been working on.

This are...

ok thanks for your help, just in case, i meant i used her windows credential in another desktop and it worked fine. not sql server credentials 

thank you so much, one last question before i try your answer... can it be something to do with the workstation ??? when i try from a different deskstop with...

thanks Jo, can you please tell me how to set up this dsn-less conection. what i usually do is from access go to the table and relink to an odbc...

what i did to the access database was to link the external sql server table by going to file , get external data, link tables, data sources, odbc, new dsn...

yes i checked my odbc conection and it is set up with windows nt authentication, in the error message: it says

win2k3-3/user .... win2k3-3 is the sql server name.

thanks for your response, they all have the same access in the database , data read, data write. any thing else i could check?

thanks for your advise, i want to create a cmd button the same thing as: tools, analyze with excel . but I don't seem to get it to work with that vba...

thank you so much!!!

thanks everyone i just rewrote the script a little and got it to work perfectly, thanks for all your help, i extremely apreciate it! have a great day

i got it to run ok with no errors but now my rows come out with all the fields as nulls, any ideas why?

thanks, but i am a little confused is it that what Michael did in his code?

Function FormatPhoneNumber(strPhone)

' strPhone parameter is the area code and phone number concatenation

Dim strNew

strNew =...