Missing Joins

[Guest]

Hello,

We recently upgraded from office 2000 to office 2003 and are having problems
with pre built queries.

Process:
We create a new Access database every month. Queries and tables are imported
from the previous month. New customer data is imported into the database for
manipulation. We then run the queries.

Problem:
Many of the queries are based of tables that have not yet been created. In
other words, they are created about 5 queries into the process. When these
queries are imported the joins in the query are lost. Whats even worse,
Access replaces all the field names with Exp1, Exp2 etc. Even after the table
is created it does not remove the Exp1 from the query as it did in Access
2000.

Question:
1. Is there a setting to correct either of these problems?
2. (if there is not a setting) Other than downgrading to the previous
version, is there another work around to these problems?

Thanks in Advance!
Robert

 

[Guest]

I would rather build a way to work with dates in a single database that holds
all my data as opposed to building a new database every month. Once you get
it working everything stays working, just adjust the window you look at your
data through by using date formulas in your queries to pull it up month at a
time./

 

[Guest]

Jeff,

Thanks for the suggestion, however, the reason we rebuild the database every
month is because the finished database is 1.5 gigs. Access currently has a 2
gig limit. Its just not possible to reuse the same database.

Thanks again!
Robert

 

[John Spencer]

Try building one database that holds all your forms, queries, code, etc and
building a second database that holds all the data. In other words, the
classic front end/backend arrangement (or a split database).

Then all you do is build a new backend database every month and if necessary
relink the frontend to the backend tables. For links to a lot of
information on the topic of database splittng see Jeff Conrad's page at

http://home.bendbroadband.com/conradsystems/accessjunkie/splitting.html