By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,136 Members | 1,089 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,136 IT Pros & Developers. It's quick & easy.

auto write for read only users

P: n/a
Hi,

I have created a DB and I want to set up a few read-only users. The
problem is that I have a few "automated" insert/delete procedures.
E.g. when the user logs in his name is recorded on a table. I can
solve this problem by granitng insert access only for the specific
table. That would be ok for this problem, but not for the one
described below....

Moreover, when you load the main data Form it automatically creates a
number of records (specified by the date). When you unload it it
deletes all the empty records. This means that either read-only users
can't access the main data Form or theat they will have insert/delete
access...

Any ideas?

thank you in advance!

Laertes
Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
If you are using update or append queries to make your automated entries,
you can specify User's or Owner's permissions for the queries. This is one
of the query properties. If you are using stored queries, right click the
background where the tables are in the query design grid and choose
Properties.

--
Wayne Morgan
Microsoft Access MVP
"Laertes" <bi******@btopenworld.com> wrote in message
news:b2**************************@posting.google.c om...
Hi,

I have created a DB and I want to set up a few read-only users. The
problem is that I have a few "automated" insert/delete procedures.
E.g. when the user logs in his name is recorded on a table. I can
solve this problem by granitng insert access only for the specific
table. That would be ok for this problem, but not for the one
described below....

Moreover, when you load the main data Form it automatically creates a
number of records (specified by the date). When you unload it it
deletes all the empty records. This means that either read-only users
can't access the main data Form or theat they will have insert/delete
access...

Any ideas?

thank you in advance!

Laertes

Nov 12 '05 #2

P: n/a
I'm actually doing it by code... like this :

......

Set rst = dbs.OpenRecordset("SELECT [date], " _
& "Count([date]) As m FROM Selectron " _
& "GROUP BY [date] HAVING [date] = #" &
Format(a, "mm\/dd\/yyyy") & "#;")
if rst!m = 1 Then
DoCmd.GoToRecord , , acNewRec
Forms![Selectron]![Date].Value = a

......

I tried adding WITH OWNERACCESS OPTION at the end of the recordset,
but still it doesn't like it...

thnx!

Laertes
Nov 12 '05 #3

P: n/a
I don't follow where you tried to add the Owner Access option. Try adding it
here:

Set rst = dbs.OpenRecordset("SELECT [date], " _
& "Count([date]) As m FROM Selectron " _
& "GROUP BY [date] HAVING [date] = #" & _
Format(a, "mm\/dd\/yyyy") & "# WITH OWNERACCESS
OPTION;")

--
Wayne Morgan
MS Access MVP
"Laertes" <bi******@btopenworld.com> wrote in message
news:b2**************************@posting.google.c om...
I'm actually doing it by code... like this :

.....

Set rst = dbs.OpenRecordset("SELECT [date], " _
& "Count([date]) As m FROM Selectron " _
& "GROUP BY [date] HAVING [date] = #" &
Format(a, "mm\/dd\/yyyy") & "#;")
if rst!m = 1 Then
DoCmd.GoToRecord , , acNewRec
Forms![Selectron]![Date].Value = a

.....

I tried adding WITH OWNERACCESS OPTION at the end of the recordset,
but still it doesn't like it...

thnx!

Laertes

Nov 12 '05 #4

P: n/a
Wayne Morgan wrote:
I don't follow where you tried to add the Owner Access option. Try
adding it here:

Set rst = dbs.OpenRecordset("SELECT [date], " _
& "Count([date]) As m FROM Selectron " _
& "GROUP BY [date] HAVING [date] = #" & _
Format(a, "mm\/dd\/yyyy") & "# WITH
OWNERACCESS OPTION;")


That won't work, since the 'owner' of this sql statement is the user that's
running this code. An alternative is to create a saved RWOP query based on
Selectron and then write the select statement against that.

--
Joan Wild
Microsoft Access MVP
Nov 12 '05 #5

P: n/a
Thanks, Joan.

That makes sense.

--
Wayne Morgan
MS Access MVP
"Joan Wild" <jw***@nospamtyenet.com> wrote in message
news:10*************@corp.supernews.com...
That won't work, since the 'owner' of this sql statement is the user that's running this code. An alternative is to create a saved RWOP query based on Selectron and then write the select statement against that.

--
Joan Wild
Microsoft Access MVP

Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.