J
Jonathan Blitz
I have built an Access database where the actual data is on an SQL Server.
The system includes many screens that all the user to perform all the
required updates to the data.
However, I wish to allow the user to perform any queries they want and to
create reports.
How can I do this without opening the database up and thus allowing them to
also update the data.
The only solution I found was to create another database in SQL Server and
define vies to the original SQL Server. Then I can control the permissions
via the SQL Server. I then created a new Accesss front end so that the users
can effectively do as they wish but not alter the data.
There must be a better way!
--
Jonathan Blitz
AnyKey Limited
Israel
Tel: (972) 8 9790365
"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."
The system includes many screens that all the user to perform all the
required updates to the data.
However, I wish to allow the user to perform any queries they want and to
create reports.
How can I do this without opening the database up and thus allowing them to
also update the data.
The only solution I found was to create another database in SQL Server and
define vies to the original SQL Server. Then I can control the permissions
via the SQL Server. I then created a new Accesss front end so that the users
can effectively do as they wish but not alter the data.
There must be a better way!
--
Jonathan Blitz
AnyKey Limited
Israel
Tel: (972) 8 9790365
"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."