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

"Read-Only" Connection: Any Such Thing?

P: n/a
I guess the good-right-and-holy path is a Read-Only user ID in the
backend DB...but that's not in the cards right here right now.

Meanwhile, I'd like to put up a "Look, but don't touch" DB for poking
around.

I would prefer to avoid MS Access's security because of portability
issues.

Anybody know of a way I could create a link that cannot update the
table behind it?
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Use a form RecordSource or a query that is a snapshot, so it is
non-updateable. Or a query that has unique records (Select Distinct) - Steve

"PeteCresswell" <Go**********@FatBelly.com> wrote in message
news:74**************************@posting.google.c om...
I guess the good-right-and-holy path is a Read-Only user ID in the
backend DB...but that's not in the cards right here right now.

Meanwhile, I'd like to put up a "Look, but don't touch" DB for poking
around.

I would prefer to avoid MS Access's security because of portability
issues.

Anybody know of a way I could create a link that cannot update the
table behind it?

Nov 12 '05 #2

P: n/a
RE/
Use a form RecordSource or a query that is a snapshot, so it is
non-updateable. Or a query that has unique records (Select Distinct) - Steve


This is just a shell of an app with hundreds of links to a DB.
It's purpose is to allow somebody to just poke around in the DB by opening
whatever tables they want. The "ReadOnly" part is just a nicety to help keep
people like Yours Truly from accidentally fat-fingering a field while browsing
directly-opened tables.
--
PeteCresswell
Nov 12 '05 #3

P: n/a
On 20 Apr 2004 09:58:55 -0700, Go**********@FatBelly.com
(PeteCresswell) wrote:

Perhaps you can use the /readonly command line argument?

-Tom.

I guess the good-right-and-holy path is a Read-Only user ID in the
backend DB...but that's not in the cards right here right now.

Meanwhile, I'd like to put up a "Look, but don't touch" DB for poking
around.

I would prefer to avoid MS Access's security because of portability
issues.

Anybody know of a way I could create a link that cannot update the
table behind it?


Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Browse more Microsoft Access / VBA Questions on Bytes