Frontpage and database access

Hi ,

I have a databse in MS access with 8 tables and around 100 queries.
Is it possible to create a single search page using all the tables and queries.

Thank You,
Nubee
nubeeAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
wobbledConnect With a Mentor Commented:
You would have to write the queries within the page itself eg SELECT * FROM the location WHERE date =  etc.  You won't be able just to link to the queries that you have already made in Access
0
 
rcmbCommented:
Yes, if you can create a single query to inner join all of the tables then you can certainly search all tables.

RCMB
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.