I have a multi-user database file, which was being used by 30+ users at
anytime for about 6 months, and it has now got corrupted possibly..I
have tried all possible options, to compact, repair, tried to open it a
thousand times, cant even import.

I have a database that is split into FE and BE.
The BE is protected with Password which the FE is providing when connected,
using VB code.
the users' path to the back end may differ from the path I used when setting

I have a form which displays user comments.  On the Load event, I apply a
filter in VBA using the following code:
''''''''''''''''''''''''
Me.Filter = "StudentID = " & Me.StudentID & " AND PracticalIDNumber = " &

If you have a DB split using a FE and a BE can you put a password on the BE
db? Or will that cause the FE /BE not to work? Basically I don't want a user
to be able to open the BE db and see the tables, values ect. The FE is
already an mde application.

I've recently deployed an Access 2000 database over a 100 Mbps WAN. When you
try to connect to the back-end from a computer in the same office (same
building) everything works fine. When you try to open the back-end from other
building the connection is painfully slow, making it ...

I'm doing IT for a small office using Microsoft Access and a
distributied database.
A winXP fileserver is storing the BE of the database on a mirror raid
system and 4 client computers access the data via a small fixed IP

I've recently deployed an Access 2000 database over a 100 Mbps WAN. When you
try to connect to the back-end from a computer in the same office (same
building) everything works fine. When you try to open the back-end from other
building the connection is painfully slow, making it ...

Hello. I'm sure that this is a common issue, but I was unable to find a
good solution. I have a multiuser (~3 users at most) database which has
a Welcome form. This form has comboboxes to Add and Edit records. If
one user Adds a record, and another has already selected the Edit

How do you modify the switchboard in a split database?
I am using Access 97 and have the front end on everyones c drive and the back
end on the network.
Thanks for all your help.

I split my database and on my front end, which is located on everyones c
drive,  I have a form with an application that when you click the button it
opens an excel spreadsheet.
It works on all of the computers in the network except one.

How can I determine path to my Backend Access2003 database? Something like
"CurrentProject.Path" usable for frontend?

I don't have very detailed needs for user security, but occasionally want a
particular user to be able to look at the database only, with no mod
capability. Made a security group with read-only priveleges . . .problem is,
one lookup drop-down does a Record Save before loading and ...

What do people consider to be good manuals on setting up and
maintaining Access for many users? I've seen some good online
references, but if one exists, I'd like a paper reference.
Thanks.

I have a general question regarding Access ADE files.  I've recently adopted
some  Access applications and have questions regarding multi-user behavior.  
I've noticed on the MDE application that multiple users can be in the same
file located on the file-server at the same time ...

I need front ends to be able to pass information between each other.  The
front ends can obviously save information into a common BE but each FE needs
to know that there's information waiting for it.  So I need a way to trigger
an event on an application on another machine.