Search results

the test is coming from, ODBC Data Source ADministrator, Microsoft SQL server DSN configuration, and then the button for Test Data Source. Also, just making sure the issue is not coming from Active Directory.... the box is in windows 2000(we are going to upgrading it next month) and my sql...

i would like to send your printscreens , can i send it to your email? the file it is too big to attach it. :o

thanks, i did it and i get the same errors, am i mission something in the min and max function? it seems that is not being recognized.... :confused:

i am not sure what you mean, add a temporary table and then drop it?

hi guys , i need help with my espressions in this view..... my espressionskeep giving me an error message... can anyone help? SELECT dbo.[query 2 b ].Expr1, dbo.[query 2 b ].Expr1 AS Customer_No, MAX(dbo.[query 2 b ].Invoice_Date) AS MaxofInvoice_Date...

here it is, thanks!!! can it be a setting i am missing in active directory for this user?, I added a sql server login for her and now she has to type the sql server login and passord everytime and it works.. so it has to be with the windows authentication... :confused:

this is what i got from another forum but don't know exactly where to put it Dim db As Database Dim rs As Recordset Dim sSql As String Dim tdf As TableDef Dim tdf_change As TableDef Set db = CurrentDb For Each tdf In db.TableDefs Set tdf_change =...

hi all, i have two 2003 access databases with linked tables to my sql server 2000. For one access database i used the upsize wizard to send my tables to a new database in sql server and for the other database i went to file, get external data, linked talbe, odbc database and created a new odbc...

i hope you did not give up on me :(

something else: when i test the connection , it says odbc driver version 03.85.1117 , but when i create the dsn and i select the sql driver it says version: 2000.85.1117, can this have something to do why i only can tested ok when i run as administrator?

hi, i hope you had a great weeekend. Yes, i am positive is a system dsn...the sql driver version is 2000.85.1117. I am sending you also printscreens of the dsn...

how do i open it with notepad?

hi did you solve this problem.???.. i am having the same one and can't solve it....

so since i can login with her credentials in my desktop and the dsn works, it means it has nothing to do with authentication?

she is an administrator to her box. I am having the same issue with another user also (same error message when trying to open the tables from access) , but all the other users can connect fine from their desktops. Everyone here in the office has windows xp. We are using a software here that to...

she sees the system dsn, however when i try to test the conection it says that sql error message 18456....('null')" , only when i run as administrator it can run ok. what do you mean with machine is locked down too tightly?

nope, on my machine, with her credentials everything is perfect, but when i go on her machine i get that error message...

when she logs in my deskstop with her credentials she could use the tables fine... and create a dsn and everything. I created a new dsn and relinked the table however still when she goes to her desktop and she logs in she can't conect to that dsn. also, when i go to her desktop , i log in...

hi, ok so i did what you said i have a couple of questions: the domain/group name login has db_datareader rights to the database on question and default database is master. (question: on the database tab, should master database also be checked or only the MB that he needs access to?) I have...

thank you for responding!!! in active directory she is part of the built in user's group What is the name of that group? domain users local/users ok so just to make sure i do this part right... Get rid of any individual SQL Accounts or Windows accounts for that individual user. I go to...