SitePoint Sponsor |
|
User Tag List
Results 1 to 5 of 5
Thread: Sharing Access Databases
-
Jul 14, 2004, 08:00 #1
- Join Date
- Mar 2002
- Location
- Bristol, UK
- Posts
- 2,240
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Sharing Access Databases
Hi all,
For a school project in a few weeks we're going to be required to create a database in Microsoft Access (unfortunately for me, as I am already competent with MySQL!).
While it may not matter in terms of scoring higher I would like to allow more than one person to be able to open and update the same database without causing sharing violations etc.
Is this at all possible?
Thanks
-SamSam Hastings
-
Jul 14, 2004, 09:04 #2
Hi,
yes it isYou may host the mdb-file on a network drive from which it can be accessed by, hm..., more than one user. But don't expect it to be a high-end high-performance database. I don't know the exact limitations but it's a simple solution for smaller environments.
Never ascribe to malice,
that which can be explained by incompetence.
Your code should not look unmaintainable, just be that way.
-
Jul 14, 2004, 09:08 #3
- Join Date
- Mar 2002
- Location
- Bristol, UK
- Posts
- 2,240
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
I tried this before but it still gives me a sharing violation
Thanks for the help though
Sam Hastings
-
Jul 14, 2004, 09:29 #4
Hi,
I'm using it here (O97/NT4) so it can be doneHave you set the permissions for the folder/file to "Change"? What's the exact error message?
Never ascribe to malice,
that which can be explained by incompetence.
Your code should not look unmaintainable, just be that way.
-
Jul 15, 2004, 07:51 #5
- Join Date
- May 2003
- Location
- Washington, DC
- Posts
- 10,653
- Mentioned
- 4 Post(s)
- Tagged
- 0 Thread(s)
I have done it alot. All users need read/write/create/delete permissions to the folder, as they have to create the LDB file.
Other thing is to hide the little save object button, as it will lock others out when one users clicks on the little disk icon and saves changes to a form.
WWB
Bookmarks