Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 24th, 2003, 10:51 AM
Registered User
 
Join Date: Jun 2003
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default How do you make a database Multi-User

I am working on a number of projects that are to be used by a number of people across the network. I have split the code and the tables into separate files and linked the the tables into the code file so that program changes can be made away from site without interfering with the data. Each time I try to link to the database on the server from an ordinary users login I get an error saying that the file is in exclusive use by someone else or I do not have the correct permissions. ( I have set the user up with all the permissions they could need, without making them an administrator )

Can anyone help this multi-user bit seems to be a bit of a black art!

Regards

Mikef
 
Old June 25th, 2003, 08:41 PM
Registered User
 
Join Date: Jun 2003
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

There are several possibilities. The first place I would look is the Advanced tab of the Tools/Options dialog. There you will find the "Default Record Locking" and "Default Open Mode" settings. The "Default Open Mode" should be set to "Shared". I would recommend the "Edited Record" lock for "Default Record Locking".

For more information, look in the on-line help. Go the "Find" tab and enter "exclusive". You will find a bevy of hits.
 
Old July 3rd, 2003, 01:39 PM
Authorized User
 
Join Date: Jun 2003
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I would also check with your network admin that Access databases are not opened exclusivly by default.

alun
 
Old July 3rd, 2003, 10:00 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 308
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Another option you could do - which does tend to come in handy - is have a function that copies the front end to the user's local hard drive, then opens it there. This way, the front end on the network isn't actually used, so it doesn't matter if it's opened exclusive or not. Also if you need to make changes to the design of the database, you make them on the one on your local drive, then copy it up to the network. Then the next time that anyone opens the database, it opens it with the changes.


There are 10 kinds of people in the world - those who understand binary - and those with friends





Similar Threads
Thread Thread Starter Forum Replies Last Post
Database Multi User Help Delvo Pro VB 6 5 February 26th, 2008 02:44 PM
ado multi user jolzy VB Databases Basics 2 October 20th, 2004 09:04 AM
How to program a multi-user app James Diamond Classic ASP Databases 1 February 2nd, 2004 11:48 AM
How do I program a multi-user app? James Diamond Classic ASP Professional 1 February 2nd, 2004 11:47 AM
Application multi-user password. mosart VB Databases Basics 2 June 16th, 2003 02:00 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.