Virtual table

J

JMorrell

The Sick & Annual Leave db that I have been working on for the last 7-8
months is finally ready for a more robust beta testing environment. One of
the actions that the db goes through is to create a temporary table (loaded
data from a recordset). This table is a source for a list box on one of my
forms. I have found that if a user doesn’t have administrative permissions on
the pc that they log on to, they can’t write to this table.

Our network administrators are not likely to give these users that level of
permission so that puts a big kink in my plans. Is there such thing as a
virtual table that I can move the record set to? Does anyone have a
suggestion as how to solve this dilemma?

tia,
 
A

Arvin Meyer

They probably don't need administrative permissions (they do not need to be
able to Take Control of a file) what they do need to run Access is Read,
Write and Delete permisdiond/ If the admin build a restricted folder with
only those permissions, you be able to run your database in that folder.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top