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 |
|
dejjan
Yak Posting Veteran
99 Posts |
 Posted - 2005-04-22 : 09:50:48
|
| Hello,I have one application - HR made in Access, but database is on SQL Server. On server it was created user EVR for that application and everything have worked properly until I changed that user not to have sysadmin role.In Access I have macro 'tables' with:Macro Name: connectionAction: OpenTableDescription: TableName - Connection, View - datasheet ..and Macro Name: workersAction: OpenForm Description: FormName - Workers, View - datasheet ...I have two buttons. First one start procedure:.. Dim stDocName As String stDocName = "tables.connection" DoCmd.RunMacro stDocName ..When I exclude sysadmin role for user EVR, that button doesn't work. Message is: Action Failed with atributes for macro tables.connectionwith one message more: HR can't find the object 'connection'.If I started another button, it started procedure:.. Dim stDocName As String stDocName = "tables.workers" DoCmd.RunMacro stDocName..and that works with little problem. Forms is opened but I could not add any record.Uh ... what to do. Don't tell me that I must return sysadmin privileges.Thanks in advanced |
|
|
|
|
|
DoCmd.RunMacro - Problems