T
Todd
I've got a database on a network to keep up with
vehicles. I have a table in the dbase called
vehiclelisting that lists all vehicles. I've also got a
table called monthlydata for entering each months activity
(i.e. mileage, gas, repairs, etc.) In the vehiclelisting
table I've got a field that identifies which region the
vehicle is located (ex: North, South, East, West).
Here is my problem. My dbase is set as shared and two
people can enter the dbase at the same time to a certain
point. Where the problem occurs is in the selectregion
form where I've got command buttons for people to select
which region they would like to enter data on vehicles
from that region (each command button sorts the
vehiclelisting table and pulls whatever region is chosen
(North, South, East, West). All the queries that these
command buttons pull from are from the vehiclelisting
table.
Could this process cause a problem in a shared database? I
don't have the dbase secured yet but will once I can get
past this point. That is why I've got the different
queries so when the dbase is secured I can disable certain
queries and macros from people in the other regions.
The message that pops up if someone is trying to chose a
command button while someone is already past that point
says something like Can't enter becauee vehiclelisting is
locked. It then states that it is in use by XXXXXXX.
What could I be doing wrong?
I'm using access 2000.
vehicles. I have a table in the dbase called
vehiclelisting that lists all vehicles. I've also got a
table called monthlydata for entering each months activity
(i.e. mileage, gas, repairs, etc.) In the vehiclelisting
table I've got a field that identifies which region the
vehicle is located (ex: North, South, East, West).
Here is my problem. My dbase is set as shared and two
people can enter the dbase at the same time to a certain
point. Where the problem occurs is in the selectregion
form where I've got command buttons for people to select
which region they would like to enter data on vehicles
from that region (each command button sorts the
vehiclelisting table and pulls whatever region is chosen
(North, South, East, West). All the queries that these
command buttons pull from are from the vehiclelisting
table.
Could this process cause a problem in a shared database? I
don't have the dbase secured yet but will once I can get
past this point. That is why I've got the different
queries so when the dbase is secured I can disable certain
queries and macros from people in the other regions.
The message that pops up if someone is trying to chose a
command button while someone is already past that point
says something like Can't enter becauee vehiclelisting is
locked. It then states that it is in use by XXXXXXX.
What could I be doing wrong?
I'm using access 2000.