If the stored procedure was newly created odds are it needs to be granted permissions to execute for the given user
Run this command
GRANT EXEC ON [Stored Proc Name] TO [USERNAME]
If the stored procedure was newly created odds are it needs to be granted permissions to execute for the given user
Run this command
GRANT EXEC ON [Stored Proc Name] TO [USERNAME]
Create A Single PDF File Per Record Report Using VBA & MS Access
This one was a tricky request. What I had was a recordset from a query in MS Access. I needed to create a report where when printed it would create one PDF file per record. MS Access has the...
Use this bit of VBA to create a list of Excel sheet name. - EASY Just add this code in VBA to the ThisWorkbook node and press F5 Sub ListSheetNamesInNewWorkbook() Dim objNewWorkbook As...