H
hall ted
I have a start form that lists buttons for 9 different
divisions. When I click on the button for division 1 it
opens my division start form. This division start form
is generic and it opens the same form no matter what
division button is pushed, however when the Division 1
button is pushed it sets the variable DIV to 1, and I
want it to pull Division 1 information from the division
table. My problem is that then when people in division 1
open the division start form, and they want to
add/edit/delete division 1 data, my expenses query
doesn't know to access div01 expenses table. If I push
division 3 button it doesn't know that expenses query is
suppose to access div03 expenses table. I tried using a
union query to access all of the tables, however the
users cannot update data in a union query. I have each
division in a separate table because I want the users to
have access to create any queries, forms, or reports they
want, and I don't know how to limit them to the table.
My final plan is to have each division have a backend in
folders on the server that only that division has
privileges to access. In other words Division 1 tables
will be in a backend database in div01 folder, Division 2
tables will be in a backend database in div02 folder and
so on. I tried to set it up that when I push Div 1
button, it copies Div 1 expenses table to expenses table
and then all queries access expenses table, however I
have found that running this over the LAN takes several
minutes to open forms. I also worry that if 2 people try
and access the database it will cause problems when the
second users has it copy div02 expenses to expenses while
div01 is doing work in the expenses table. I know this
is wordy, but any help is appreciated.
divisions. When I click on the button for division 1 it
opens my division start form. This division start form
is generic and it opens the same form no matter what
division button is pushed, however when the Division 1
button is pushed it sets the variable DIV to 1, and I
want it to pull Division 1 information from the division
table. My problem is that then when people in division 1
open the division start form, and they want to
add/edit/delete division 1 data, my expenses query
doesn't know to access div01 expenses table. If I push
division 3 button it doesn't know that expenses query is
suppose to access div03 expenses table. I tried using a
union query to access all of the tables, however the
users cannot update data in a union query. I have each
division in a separate table because I want the users to
have access to create any queries, forms, or reports they
want, and I don't know how to limit them to the table.
My final plan is to have each division have a backend in
folders on the server that only that division has
privileges to access. In other words Division 1 tables
will be in a backend database in div01 folder, Division 2
tables will be in a backend database in div02 folder and
so on. I tried to set it up that when I push Div 1
button, it copies Div 1 expenses table to expenses table
and then all queries access expenses table, however I
have found that running this over the LAN takes several
minutes to open forms. I also worry that if 2 people try
and access the database it will cause problems when the
second users has it copy div02 expenses to expenses while
div01 is doing work in the expenses table. I know this
is wordy, but any help is appreciated.