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

preventing user to access/see/import/linking tables

P: n/a
hi all,

i'm searching the most secure way to prevent users from able to
approach tables in a mdb file
any ideas?
Feb 12 '08 #1
Share this Question
Share on Google+
5 Replies


P: n/a
On Tue, 12 Feb 2008 03:13:10 -0800 (PST), thread <ya******@gmail.com>
wrote:

The most secure, albeit not perfectly secure, way is to use Workgroup
Security. Phased out in A2007, so that should tell you something.
If you want real security, SQL Server can provide it, including the
free Express edition.

-Tom.

>hi all,

i'm searching the most secure way to prevent users from able to
approach tables in a mdb file
any ideas?
Feb 13 '08 #2

P: n/a
"Tom van Stiphout" <no*************@cox.netwrote in message
news:fj********************************@4ax.com...
On Tue, 12 Feb 2008 03:13:10 -0800 (PST), thread <ya******@gmail.com>
wrote:

The most secure, albeit not perfectly secure, way is to use Workgroup
Security. Phased out in A2007, so that should tell you something.
If you want real security, SQL Server can provide it, including the
free Express edition.

-Tom.
..mdw is phased out in A2007???
Is there an alternative?
Is it backwards compatible with A2k?
tks,
Fred Zuckerman
Feb 13 '08 #3

P: n/a
On Tue, 12 Feb 2008 20:29:27 -0800, "Fred Zuckerman"
<Zu********@sbcglobal.netwrote:

Yes. You can still run it, but not create it.

I am writing code to check with Active Directory as to who is a member
of what group.

Define "it".

-Tom.

>"Tom van Stiphout" <no*************@cox.netwrote in message
news:fj********************************@4ax.com.. .
>On Tue, 12 Feb 2008 03:13:10 -0800 (PST), thread <ya******@gmail.com>
wrote:

The most secure, albeit not perfectly secure, way is to use Workgroup
Security. Phased out in A2007, so that should tell you something.
If you want real security, SQL Server can provide it, including the
free Express edition.

-Tom.

.mdw is phased out in A2007???
Is there an alternative?
Is it backwards compatible with A2k?
tks,
Fred Zuckerman
Feb 13 '08 #4

P: n/a
As far as I know, Access security is still available for MDB files created
in Access 2007, but not for the new ACCDB file format. You are supposed to
use the security provided by SharePoint or by the server database you are
using as a back-end. If you are using ACCDB as a back-end, no security is
supported.

In the past, I've worked on Access client applications, to which we applied
Access security, with server DB back ends, in which we applied the server
DB's security. Now, it seems, only the server's security can be used.

Larry Linson
Microsoft Office Access MVP
"Fred Zuckerman" <Zu********@sbcglobal.netwrote in message
news:Pj*************@nlpi068.nbdc.sbc.com...
"Tom van Stiphout" <no*************@cox.netwrote in message
news:fj********************************@4ax.com...
>On Tue, 12 Feb 2008 03:13:10 -0800 (PST), thread <ya******@gmail.com>
wrote:

The most secure, albeit not perfectly secure, way is to use Workgroup
Security. Phased out in A2007, so that should tell you something.
If you want real security, SQL Server can provide it, including the
free Express edition.

-Tom.

.mdw is phased out in A2007???
Is there an alternative?
Is it backwards compatible with A2k?
tks,
Fred Zuckerman


Feb 13 '08 #5

P: n/a
On 13 פברואר, 08:01, "Larry Linson" <boun...@localhost.notwrote:
As far as I know, Access security is still available for MDB files created
in Access 2007, but not for the new ACCDB file format. You are supposed to
use the security provided by SharePoint or by the server database you are
using as a back-end. *If you are using ACCDB as a back-end, no security is
supported.

In the past, I've worked on Access client applications, to which we applied
Access security, with server DB back ends, in which we applied the server
DB's security. *Now, it seems, only the server's security can be used..

*Larry Linson
*Microsoft Office Access MVP

"Fred Zuckerman" <Zuckerm...@sbcglobal.netwrote in message

news:Pj*************@nlpi068.nbdc.sbc.com...
"Tom van Stiphout" <no.spam.tom7...@cox.netwrote in message
news:fj********************************@4ax.com...
On Tue, 12 Feb 2008 03:13:10 -0800 (PST), thread <yaniv...@gmail.com>
wrote:
The most secure, albeit not perfectly secure, way is to use Workgroup
Security. Phased out in A2007, so that should tell you something.
If you want real security, SQL Server can provide it, including the
free Express edition.
-Tom.
.mdw is phased out in A2007???
Is there an alternative?
Is it backwards compatible with A2k?
tks,
Fred Zuckerman-הסתר טקסט מצוטט-

-הראה טקסט מצוטט-
so if i understand correctly,there is no option to secure ACCESS
within its functionalities but only by outsource softwares
Feb 13 '08 #6

This discussion thread is closed

Replies have been disabled for this discussion.