The other thing you need to do on your site is correct the usage of English.  there for their and so on.

No American would use the site because of the...

The other thing you need to look at is running the Access application on each local machine and NOT, repeat, NOT, from the server.  If you have everyone using the...

The MSDE is a good tool and will run locally.

But, what you want to do is really simple in Access.  Open Access, create a new database.  Create an ODBC connection...

Access can work fine up to about 10 users.  But, only if it is programmed correctly.  And I do mean programmed.  You cannot use wizards to do it.

I stopped use...

Gee, maybe if you had said that at the beginning it would have helped.

Sounds like you have a very poor design.  First, column names should not be numbers alone. Second,...

If you do it like I told you to above, then you do not have to worry about deleting parts of it.

You need to post text, the graphic does not work.

Essentially with Access the best way to do this is to have 2 queries.  The first suffixed with _0 the second with _1.  The _0 query contains your basic SQL...

Case Studio 2 turned out to be very good.  It will also do data flow diagrams.  I believe the price is around $400.  It will do more databases than ERWin...

Not as much as you are thinking.  Forcing everything into a single DB would actually, IMHO, create more of a problem.

Edward,

The number of objects you create is going to be the same, no matter how many databases you create.  Remi is right on the mark with his comments.

EM will not...

There is no way that what you are trying to do will ever work.  You need to use a stored procedure or the table directly to bind an Access form.

You...

At work, I use ERWin 4.14.  It has most of the bugs worked out of it and seems pretty stable.  It is expensive unless your company is going to buy it for...

All of our data warehouse tables have four columns added:

Audit_Create_Date, Audit_Create_UID, Audit_Modify_Date, and Audit_Modify_UID

We use these on the truncate and load tables also.  Why?  It is just our "standard."  We...

Farrell,

Correct.  You should not use the upsizing wizard to load data.  Sometimes you can have issues with the datatypes it translates to.  Once the corrections are made, if any, then...