Re: Creating a Report via VBA
- From: "Larry Linson" <bouncer@xxxxxxxxxxxxx>
- Date: Thu, 05 Jun 2008 01:07:15 GMT
I suspect there is not a way to do so, just considering that you need to
give the user _all_ permissions on the folder where the data is located --
so even outside Access, a user could "do damage" to data in that folder,
whether on purpose or accidentally. But, this is not an area where I really
have any expertise, so someone else would have to provide you a "definitive"
answer.
Larry Linson
Microsoft Office Access MVP
"RLN" <nospamrln@xxxxxxxxxx> wrote in message
news:1212503934_3514@xxxxxxxxxxxxxxxxxxxxx
The separate front-end need only have read access to the actual data<<
Larry,
This idea of a 2nd front end is good. I did this sort of thing with
another app 2 years ago that had a SQL Server back end. I basically set
up a 2nd login ID in the SQL Server database that ended in "RO" (for
read-only) and used that login on the startup form of this 2nd front end
mdb
I'm trying to figure out if there is a way to do this same type of thing
with a 2nd ID where Access is the back end rather than SQL Server.
On this 2nd front end, is there a way in Access to link to the tables
(in my backend .mdb) in a "read-only" state?
RLN
*** Sent via Developersdex http://www.developersdex.com ***
.
- References:
- Re: Creating a Report via VBA
- From: Larry Linson
- Re: Creating a Report via VBA
- From: RLN
- Re: Creating a Report via VBA
- Prev by Date: Excel 07 & Access not playing well together
- Next by Date: Re: Date Range Variable
- Previous by thread: Re: Creating a Report via VBA
- Next by thread: FREE Website Hosting AR4
- Index(es):
Relevant Pages
|
