Can also reduce performance as all the database objects are sent across the network.
This option might work for you if only a few people are expected to use the database at the same time and users don’t need to customize the design of the database.
We're thinking of "growing" a little MS-Access DB with a few tables, forms and queries for multiple users.
(Using a different back-end is another, but more long-term option that is unfortunately currently not acceptable.) Most users will be read-only, but there will be a few (currently one or two) users that have to be able to do changes (while the read-only users are also using the DB).
It's crackable, yes, but your users would be committing a firable offense by breaking it, so it might be sufficient.Microsoft is conducting an online survey to understand your opinion of the Msdn Web site.If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site. This article discusses key best practices to deploy your Access database.This item is a must to make upgrades to your end users easier.Nobody has really answered this in any complete fashion. One might think that you want to use record-level pessimistic locking, but the fact is that in the vast majority of apps, two users are almost never editing the same record.The information on setting locks in the Access options has nothing to do with read vs. Now, obviously, certain kinds of apps might be exceptions to that, but if I ran into such an app, I'd likely try to engineer it away by redesigning the schema so that it would be very uncommon for two users to edit the same record (usually by going to some form of transactional editing instead, where changes are made by adding records, rather than editing the existing data).There are several ways that you can share an Access database depending on your needs and resource availability.In this article, we’ll take a look at the options available and the benefits of each option, and give you resources for more information on a method that would work for you.This article provides an overview of the methods that you can use to share an Access database, and the factors that you should consider when you decide which method is right for you.It also provides links to more detailed information about each method.