Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Read only - linked table

6 views
Skip to first unread message

dejaqhsa

unread,
Jul 17, 2006, 10:06:01 AM7/17/06
to
Hi
Huge thanks to anyone who can help.

Is it possible to make a linked table "read-only"?

So that when you go in the original table it is ok and you can make changes,
but when you access the table via a link it is read only?

Cheers
Dejaqhsa

Rick Brandt

unread,
Jul 17, 2006, 10:37:14 AM7/17/06
to

You could create a query that pulls in the data from the table instead of
using a link. Then you can make the query read only by setting the
RecordSetType to Snapshot. You would use the IN clause to reference the
remote table...

SELECT * FROM TableName IN 'Path to other MDB File'

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


Pieter Wijnen

unread,
Jul 17, 2006, 10:40:34 AM7/17/06
to
yes, via tools / security / user & Groups permissions

Pieter

"dejaqhsa" <deja...@discussions.microsoft.com> wrote in message
news:0B63B778-8699-48F8...@microsoft.com...

Pieter Wijnen

unread,
Jul 17, 2006, 10:40:34 AM7/17/06
to
yes, via tools / security / user & Groups permissions

Pieter

"dejaqhsa" <deja...@discussions.microsoft.com> wrote in message
news:0B63B778-8699-48F8...@microsoft.com...

--
----------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 4231 spam emails to date.
Paying users do not have this message in their emails.
Get the free SPAMfighter here: http://www.spamfighter.com/len


0 new messages