Database help

C

Chris Savedge

I created a daily reporting database about 4 years ago so our customer service department could run a multitude of different reports as they needed to. The database sets out on our server and all of the users have a link to it on their desktops. 99% of the time this database functions very well but every once in awhile the users will get halt messages or a message that says the database is locked. When I go out and look to see who is in the database I notice that the LDB file that is attached to a user says things like 5 locks or 7 locks? First I would like to know if you guys have any suggestions about my set up and also what is the LDB locking situation all about and does it cause problems?

Thanks so much for your time,
Chris
 
6

'69 Camaro

This question is already answered in the microsoft.public.access.security
newsgroup. Please don't multi-post the same question in multiple
newsgroups, because it's difficult for readers to chase other readers'
responses to the same question in order to prevent repeating the same
information.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)


I created a daily reporting database about 4 years ago so our customer
service department could run a multitude of different reports as they needed
to. The database sets out on our server and all of the users have a link to
it on their desktops. 99% of the time this database functions very well but
every once in awhile the users will get halt messages or a message that says
the database is locked. When I go out and look to see who is in the
database I notice that the LDB file that is attached to a user says things
like 5 locks or 7 locks? First I would like to know if you guys have any
suggestions about my set up and also what is the LDB locking situation all
about and does it cause problems?

Thanks so much for your time,
Chris
 
6

'69 Camaro

Hi, Chris.
I apologize for this but I didn't know what group would be best.

Actually, you picked excellent newsgroups to post your messages, because
knowledgeable people here can read your posts and help you with your
problem. (On weekends, only about one-third to one-half of all posts in the
microsoft.public.access newsgroup are questions for the English-language
version of Microsoft Access, so there aren't many Chinese- , Vietnamese- or
Spanish-speaking experts here to help troubleshoot the E-mail problems and
operating system problems for those lost souls who post their desperate
messages here.)

However, the ability to send the same message to multiple recipients is
available by using a semicolon or comma to separate each recipient from the
others. The readers in the newsgroups will get to read everybody's response
(so as not to repeat what someone else has already written), no matter which
newsgroup that person replied to -- as long as the poster doesn't delete the
other newsgroup recipients from the header). Check the heading on this
message, which will be posted in the both the microsoft.public.access and
the microsoft.public.access.security newsgroups, for an example of this.

Since you are using Outlook Express 6.0 to post your messages, the Help
topic, "Posting messages to newsgroups," is available for your reading
pleasure.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)


Chris Savedge said:
I apologize for this but I didn't know what group would be best.

--
CHRIS SAVEDGE
message news:[email protected]...
This question is already answered in the microsoft.public.access.security
newsgroup. Please don't multi-post the same question in multiple
newsgroups, because it's difficult for readers to chase other readers'
responses to the same question in order to prevent repeating the same
information.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)


I created a daily reporting database about 4 years ago so our customer
service department could run a multitude of different reports as they needed
to. The database sets out on our server and all of the users have a
link
 
Top