Read-Only linked tables

  • Thread starter Thread starter Dan Hohmann
  • Start date Start date
D

Dan Hohmann

I'm trying to publish a data warehouse for use by the
general public here at work. I'm going to give them a db
that will automatically link to all the tables in this
data warehouse. The problem that I'm having is that I
want to give the users read-only access to the database
but I don't want to do this via permissions on the
warehouse file, I'd rather I get read-only access, too at
times so I don't mess up any data. Any help would be
greatly appreciated.
Sincerely,
Dan
 
(Plse post OS version and Access version in future post. If you are talking
about some other software, you are in the wring newsgroup).

If you are using Access, you can use Query specifying Recordset type
"Snapshot" which we make the data Read-Only".
 
Sorry. WIN2k and Office2k.
-----Original Message-----
(Plse post OS version and Access version in future post. If you are talking
about some other software, you are in the wring newsgroup).

If you are using Access, you can use Query specifying Recordset type
"Snapshot" which we make the data Read-Only".

--
HTH
Van T. Dinh
MVP (Access)






.
Click to expand...
 
Not all the queries "hold" their Snapshot Recordset Type.
On some queries I can create them with a Snapshot
Recordset Type, save'em and close'em, and then, when they
are re-opened they're Dynaset. If I change them back to
Snapshot I get a "Record is Deleted" error when I go to
save and I can't save it as Snapshot.
Dan
 
Snapshot type is the "lowest" type since Access / JET does not have to
handle the additions or updates. You should always be able to create
Snapshot Type. I have never had any problem changing the Query from Dynaset
to Snapshot.

Have you upgraded your Win2K and Access2K / Office2K with all the Service
Releases (SR) / Service Packs (SP)? This could be a bug in your Access2K
installation as the original release of Access2K had a lot of bugs. You
must upgrade your Access / Office2K to at least SR-1a.(This comes back to
why you should post the OS, the Access version and SR/SP applied on your
installation).
 
Back
Top