Accessing different tables from the same query

[hall Ted]

I have a front end and a back end data base, and I have a
problem. I want each user to open 1 form, and I have
that form accessing a query. If a user from division 1
pushs div 1 button I want everything to access the table
called div 1. If a user pusheds the division 3 button I
want everything to access div 3 table. I separated the
data into different tables for security reasons. I don't
want div 1 to see div 3 data and so on. I want the users
to have the freedom to creat their own forms, reports,
and queries and to be able to add edit or deltet their
own records in the table so I can't limit permissions to
the table. By using the front and back end database I
can put each div table in it's own folder that only those
people at that division can access. I have tried using a
union query that combines the data from all tables,
however union queries are not updatable. Anyone know a
way to have a query access different tables?

 

[Tom Wickerath]

You can use the technique known as QBF (Query by Form), which involves building the SQL
statement using VBA code. I can send you a QBF example, which should be fairly easy to
modify to access different tables. If you'd like such a sample, send me a private e-mail
(note: the reply to address of this message needs to be modified to work).


Tom
___________________________________

I have a front end and a back end data base, and I have a
problem. I want each user to open 1 form, and I have
that form accessing a query. If a user from division 1
pushs div 1 button I want everything to access the table
called div 1. If a user pusheds the division 3 button I
want everything to access div 3 table. I separated the
data into different tables for security reasons. I don't
want div 1 to see div 3 data and so on. I want the users
to have the freedom to creat their own forms, reports,
and queries and to be able to add edit or deltet their
own records in the table so I can't limit permissions to
the table. By using the front and back end database I
can put each div table in it's own folder that only those
people at that division can access. I have tried using a
union query that combines the data from all tables,
however union queries are not updatable. Anyone know a
way to have a query access different tables?