Any SQL pros?

[chris1911]

Okay, I don't have a ton of experience on workgroups. Have you tried creating a user with the same name on the SQL server as the client and give that user admin priveleges on the server? Passwords need to match obviously. Just a shot in the dark. MSQL will dovetail itself into active directory but I don't know what it does with workgroups to be honest.

ETA: I mean not a user in the database, but a user on the OS. Also, you can apply permissions to a database, but depending on the SQL server you have sometimes the tables don't get their permissions set as a child of the database. Make sure your permissions are set on all the tables, indexes, and stored procedures if there are any.

I'll give this a try tomorrow, thanks.

[chris1911]

Just an update... After two days I figured it out. Apparently still having the Fox Pro DSN in ODBC administration will make that software not work.