On May 15, 6:10 pm, "Danny J. Lesandrini" <
da...@lesandrini.com>
wrote:
> I just met with a new client who needs a couple things that, last I heard,
> Access 2010 doesn't support: Security and Replication (synchronization).
>
> How can a database be secured in Access 2010? Let's assume this is a
> contact database with information that cannot (if stolen) be made public.
> Assume also that there are various groups that are allowed to see only
> those contacts to whom they have rights. How is this handled these days?
>
> I assume I'd roll my own login system and manage data access in VBA.
> Can the tables be reliably obfuscated? Does suppressing the F11 action
> really work to prevent users from getting to the raw data?
>
> As for "replication", I know that's not supported in Access 2010. What I
> think they really need is "synchronization". Let's say there are 3 users
> who enter and update contact info and 500 users who need only access
> the data and search for contacts. Because they want this info to be
> available in case of a disaster, they don't want a "web based" solution
> but rather, want a local Access database that regularly gets "synched"
> with the main database. What approach comes to mind?
>
> I was thinking of using a single Access file with local tables that are
> truncated and reloaded with data whenever a network connection is
> detected. When off-line, as would be the case in a disaster, the list
> would be as current as the date of last network access.
>
> Ideas?
> --
> Danny
Lesandriniwww.lesandrini.com/datafast/
I've followed this thread but it is now into things I'm never going to
be concerned with.
Unfortunately, David Fenton passed away so the person in the
replication know-how can't help I decided to punch in his name and
the word Replication into Google and got this link.
http://dfenton.com/DFA/Replication/index.php?title=Replication_Wiki_Frequently_Asked_Jet_Replication_Questions_%28FAQ%29
I did this a while ago. I created a front end/back end. I opened the
backend, and encrypted the database with the password. I then opened
the frontend, and encrypted it. With the tables linked, I was able to
open the fronted, be prompted for a pw and was able to use the tables
in the backend.
The next step would be to make the front end an accde. Lock the
database window down and scroll-break and not full menus.
I'd think the DB is pretty safe at this point. If a person stole both
fe/be, the person would not be able to change the table links...at
least I don't think so...
JMT