Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-01-30 : 13:44:29
|
| Don writes "I have 1 particular user that is getting a 2580 runtime error in Access. I have an Access.adp file interfaced into SQL Server 2000 SP4 database. At startup of this application program the database objects (tables/queries/etc) should display inside of the Access 2002 program file, however for this user they do not display and this makes the program inoperable. Each time an object is referenced inside a form program it displays a 2580 runtime error.The only possible solution I found was that the user should have the sysobject in the database be identified as select (which has been set) and still doesn't work. I have tried this same program under another user and the program operates properly, so I believe I elminated the issue with the program. We have tried this program on different computers with the same user account (that doesn't work) and we get the same result of an inoperable program. Obviously this points me back to some environment configuration and/or security settings in the database for this user. I am using a ODBC connection that works inside the program. If I start the program, do file>connection>and test the connection the connection works, but the objects are not read from the database. Can't find any solution available. Can you provide me any help on this issue. I am running Access 2002 and SQL Server 2000/SP4 on Server 2003/SP1 platform with all related security patches installed. The access program has been run both from the XP/SP2 workstation and Server 2003 with no success.Thanks in advanceDon Lewis" |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-02-01 : 09:18:42
|
| Sounds to me like they have access to the database, but don't have any permissions on the objects you are trying to retrieve in that database, instead of just checking the user, check all theur permissions and set them manually if you have to.. |
 |
|
|
|
|
|
2580 Runtime Error adp.sqlserver 2000