Anyone using "KeyedAccess"

A

a a r o n _ k e m p f

I am kinda interested by it. But I really don't understand a couple
of things about it.

I think that SQL Server has all the security I need.
mySQL can restrict logons to a particular IP address.

if SQL Server had that-- I think that the SQL route would be a no-
brainer (as if it isn't already)
 
T

Tony Toews [MVP]

a a r o n _ k e m p f said:
I am kinda interested by it. But I really don't understand a couple
of things about it.

I think that SQL Server has all the security I need.
mySQL can restrict logons to a particular IP address.

if SQL Server had that-- I think that the SQL route would be a no-
brainer (as if it isn't already)
Click to expand...

You clearly understood nothing about the purpose of "KeyedAccess"
Which has nothing to do with storing the data in Access MDBs or SQL
Server.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
A

a a r o n _ k e m p f

It is a security dongle.

If your database automagically worked with Windows Authentication--
you wouldn't need a dongle.
SQL Server (ADP) works great with Windows Authentiction

with Linked Tables; you need to write about 20 lines of code to do
anything with SQL Server.

It's just that JET is too flakey to have security.. so they yanked
it.. and you guys don't have the BALLS to upsize to SQL
 
A

a a r o n _ k e m p f

and for the record.. _EVERYTHING_ concerns 'storing the data in SQL
Server'
 
A

a a r o n _ k e m p f

people can use ADP to secure their app without a problem. it's a
secure format.
JET IS NOT.

Maybe instead of beating around the bush-- and inventing new things--
you should take a look at the worlds most popular database
www.microsoft.com/sql

Make an ADE, kick people out of the front end.. and there is ZERO
chance that people can get to the data or the schema.

So yes.. _EVERYTHING_ comes down to 'YOU SHOULD FOCKING USE SQL
SERVER, IDIOTS'
 
Top