Although there are not stored procedures in ACCESS, there are stored queries.
This is a web page that tells one how to do stored queries.
http://www.stardeveloper.com/articles/display.html?article=2001050101&page=1
I had a whole bunch of trouble getting around the MSysObjects problem.
'Record(s) cannot be read; no read permission on 'MSysObjects''
This page gave the following instructions on how to set the privileges.
http://forums.belution.com/en/sql/000/015/39.shtml
In MS Access
Select Tools-Options-View-Show-System objects, Click OK
(this makes the system object tables visible)
Select Tools-Security-User and group Permissions
Select MSysObjects from object names
Add 'Read Design' and Read Permissions
The basic problem is that MSysObjects is undocumented in ACCESS. That makes it hard to figure out what to do.
Tuesday, February 13, 2007
Subscribe to:
Posts (Atom)