If it works fine on some computers but not others, my guess is it's something with the permissions on sql server for what it recognizes as the user on the computers it doesn't work or it's ODBC DSN related for that computer. Have you tried logging into the computer it doesn't work on with the user name and password of the computer it does work on to see if it's user related or computer related?
Have you also checked the ODBC DSN for the computer it doesn't work on? If it's ODBC DSN related (for that computer), you can try some code in the MS Access Code Bank which automatically creates an ODBC DSN name for the computer being used or just create an ODBC DSN for that computer and see if it works. ALWAYS make sure the ODBC DSN name is EXACTLY the same name for EVERY computer which accesses that same database or you will have problems. If not, it will work fine one time and not the next time after someone else has gotten into it with a different ODBC DSN name (and confuse the hell out of you on why it works sometimes and not other times.)
Last edited by pkstormy; 07-14-07 at 14:43.
Expert Database Programming
MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)