Back-end

[Matt Dawson]

Is it possible to open the same table through a couple of different forms.

I have networked my database and left the bank-end on the network drive and
the other users each have a copy of the front end.

Can they still all use the same form simultaneously even if it runs off the
same table as at present, i keep gettign the message "locked out".

Many Thanks,
Matt
p.s. Sorry Joan, am very rushed on this matter

 

[Douglas J. Steele]

There should be no problem with multiple users all trying to read the same
table simultaneously. However, if they try to update the same page of the
table simultaneously, then you will get a "locked" message.

 

[Matt Dawson]

How do you mean by the "same page"

At the moment no more than one user can access the table at one time let
alone open the form to edit the details

Matt

 

[godiva]

Since multiple users are actually accessing the data through their own
front end, they won't cause each other to get locked out. this is
because they are not all in the same front end at the same time
accessing the same form. It is advisable to change the Record Locks
property on the form to Edited Record so that it locks the record the
user in question is on. Then if another user attempts to edit that same
record, the locked message will appear. but if any other user is on
some other record in that same table, there won't be any issues.

 

[Matt Dawson]

But they are all running off the same table and it says that as one person
has access to the table then the others are "locked out".

If i change the edited record, will this solve the problem?
Matt

 

[Granny Spitz via AccessMonster.com]

Can they still all use the same form simultaneously even if it runs off the
same table as at present, i keep gettign the message "locked out".

Go to Tools | Options | Advanced. Make sure the default open mode is "Shared.
" Set default record locking to "No locks." Make sure the check box for
"Open databases using record-level locking" is checked. Compile the code and
compact the database. (Making an MDE is a good idea at this point, too.)
Have everyone exit out of the application and make sure that the LDB file for
the back end is deleted. (If everyone doesn't exit the database your setting
for "Open databases using record-level locking" will be ignored, because
whatever the setting was for the first person to open the database is applied
to all subsequent users until the database closes.) Redistribute this new
front end file to all users.

Now let the users open the database with the new front end. The users
shouldn't be locking each other out of the form any longer, but they can get
a warning that someone else is editing the record they want to edit if
someone else is already updating it.

 

[Douglas J. Steele]

Access stores records in pages. They used to be 2K blocks: I believe they're
4K blocks now. The number of records on a page will depend on the size of
each record.