We found it. We have to give the targeted users SELECT rights to the SQL database.
If we ever want them to be able update then we will have to make that change too. Thanks again to all! Dennis ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Lawrence Lustig Sent: Tuesday, April 14, 2009 1:30 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Compiler << We have done further testing. On the same computer if I log in as me it works. If I log in as another user it does not. I think the issue must be access rights to the SQL database. >> Could be access rights, could be a user DSN instead of a system DSN. -- Larry
