Improve company productivity with a Business Account.Sign Up

x
?
Solved

Multi User database

Posted on 2001-09-12
11
Medium Priority
?
246 Views
Last Modified: 2006-11-17
My access database was multi-user but recently, after moving it to another server it became single user.  Is this a workgroup issue or something?

I've checked the options menu to make sure it is shared.
0
Comment
Question by:keypusher
11 Comments
 
LVL 7

Expert Comment

by:Nosterdamus
ID: 6478714
Hi keypusher,

What is exactly the problem?

Nosterdamus
0
 
LVL 59
ID: 6479267
Make sure that all users have full read/write/delete priviledges for the directory where the MDB is stored.

If Access cannot create a LDB file, it will open in exclusive mode.

Jim.
0
 

Author Comment

by:keypusher
ID: 6483127
I get a message something like: You can not save at this time it is being edited by another user.  There is a .ldb file and I checked the read/write privileges.
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
LVL 59
ID: 6483152
OK that's something else again.  You didn't say which version of Access this is, but until A2000, Access locked on pages and not records.

 This means that a single user can cause more then one record to be locked and hence, the dialog your getting.

There is a workaround for this, but before I go further, what version are we talking about?

Jim.
0
 

Author Comment

by:keypusher
ID: 6483624
Access '97
0
 
LVL 59

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 120 total points
ID: 6483650
Well then you defintly locking on pages.  The workaround I mentioned is to pad the records enough so that only one record can fit on a page (Access records cannot span pages).  Since a page in A97 is 2048 bytes, you need to ensure that the page is larger than 1024 bytes.

This is done by calculating the current record size and then adding enough text fields filled with something to pad the record out.

I can go into more detail if you wish.
Jim.
0
 

Author Comment

by:keypusher
ID: 6483694
I little bit more detail would be helpful.
0
 
LVL 59
ID: 6484576
What you'll need to do is first figure out the existing record size.  OLE and memo fields are stored seperately from the rest of the record, and a 16 bytes pointer is put in wil the rest of the record unless they use 32 bytes or less.  

So for a record you have:
7 bytes overhead
1 byte overhead for each defined field
size for fields as you would expect (4 bytes for integer and single, 8 for long and double, etc).

Text fields however are special as they only store what's in the record.  In other words if I define a text field with 50 as the maximum length, and put a "A" in the field, only 1 character of storage of space is used.  So for text fields, assume one byte.

Total up all your existing fields and figure out the pad length (1024- record size).  Let's say you need 734 bytes of padding.

  734/255 (maximum text fields) = 2.878

 in this case, you'd round that off to 3 text fields of 255 characters each. Open the table in design view, add 3 text fields and set the deafult values to:

="xxxxxxxxxxxxxxxxxxxx.....xxxxxxxxxxx"  (255 "x")

  You must do this.  If you don't put something in the field, the space won't get used.

  Remember to run an update query on existing records as the default value only applies to new records.

Questions?
Jim.
0
 

Expert Comment

by:amp072397
ID: 6784154
keypusher:

You have many open questions:

http://www.experts-exchange.com/jsp/qShow.jsp?qid=20159419
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20173252
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20179072
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20182130
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20184408
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20181662

To assist you in your cleanup, I'm providing the following guidelines:

1.  Stay active in your questions and provide feedback whenever possible. Likewise, when feedback has not been provided by the experts, commenting again makes them receive an email notification, and they may provide you with further information. Experts have no other method of searching for questions in which they have commented, except manually.

2.  Award points by hitting the Accept Comment As Answer button located above and to the left of that expert's comment.

3.  When grading, be sure to read:
http://www.experts-exchange.com/jsp/cmtyQuestAnswer.jsp#3
to ensure that you understand the grading system here at EE. If you grade less than an A, you must explain why.

4.  Questions that were not helpful to you should be PAQ'd (stored in the database for their valuable content?even if not valuable to you) or deleted. To PAQ or delete a question, you must first post your intent in that question to make the experts aware. Then, if no experts object after three full days, you can post a zero-point question at community support to request deletion or PAQ. Please include the link(s) to the question(s).
CS:  http://www.experts-exchange.com/jsp/qList.jsp?ta=commspt
At that point, a moderator can refund your points and PAQ or delete the question for you. The delete button does not work.

5.  If you fail to respond to this cleanup request, I must report you to the Community Support Administrator for further action.

Our intent is to get the questions cleaned up, and not to embarrass or shame anyone. If you have any questions or need further assistance at all, feel free to ask me in this question or post a zero-point question at CS. We are very happy to help you in this task!


thanks!
amp
community support moderator

9/18
0
 
LVL 54

Expert Comment

by:nico5038
ID: 6983068
for keypusher

It's time to clean up this TA, so I will leave a recommendation in Community Support that this question is:
 - Answered by: JDettman  
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
0
 
LVL 5

Expert Comment

by:Netminder
ID: 6997556
Per recommendation, force-accepted by
Netminder
CS Moderator
0

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

606 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question