I will try and explain the scenario as best i can...
Ultimately, i will have 3 tables... one table with values and the other two
that map to new values for the old table...
TABLE1:

I converted an Access application that used to have a MDE front-end
(distributed to each user) with a MDB back-end on a share.  It now has a
MDE front-end with linked ODBC SQL Server 2000 tables as the back-end.
Is it a bad practice to place the MDE front-end on a network share

I just finished creating my first all-inclusive MS-Access application. Ideally, I would prefer to prevent mischievous users from accessing everything except the switchboard items. This would include the menu system and except for the "print" shortcut button, all the control ...

How to Turn $5 into $15,000 in 30 Days with PayPal
I WAS SHOCKED WHEN I SAW HOW MUCH MONEY CAME FLOODING INTO MY PAYPAL
ACCOUNT
I turned $5 into $14,706 within the first 30 days of operating the

How can i model relation n - 0:1 in access? by default it is n - 1 but
i dont want the other side of association to be obligatory...

Is there a way to summarize text in a report section footer, almost the
equivalent of =Sum(Quantity) for text.
One order can contain multiple line items of either the same product or
of several different products. In my report the detail is set to

How does one set up a multi table runtime parameter based on fields
selected from  Combo boxes (4 to be exact)  for a form or report. Yes
it is possible I have seen it but not in Access.
I need some clues as I have tried different options without success. ie

We can use a stored procedure (or JET query) as a method of the
connection object.
example:
CurrentProject.Connection.Query1

A girl died in 1933 by a homicidal murderer. He buried her in the
ground when she was still alive. The murdered chanted, "Toma sota
balcu" as he buried her. Now that you have read the chant, you will
meet this little girl. In the middle of the night she will be on your

1. Does anybody know, how to handle the error massage 3114 in Access
2003 with Jet4.0, Version 4.0.8618.0?
According to http://www.mvps.org/access/bugs/bugs0010.htm the jet-engine
3.5 can be updated to avoid the error. But what to do in 4.0?

I am currently writing a cross-tab query using the following details:
Level Allocated
tbl Contracts
Group By

I have four columns in one table. I want to add all the records in each
of these columns into 1 column in another table. Any ideas??

I have a table called PropertyCode with 4 properties as fields, with a
list of paddocks under each. I would like to use these as a parameter
in my query, where any records which have a paddock listed in either of
the four columns is returned. Ideas?

I want to create an employee license plate database and need help with
the best table design.
I was thinking three tables:
1) tblEmployees

Dear reader,
I have a Form with a SubForm.
On the MainForm there is a field receiving his content from a group query.
If a change or append or delete a record in the SubForm the group query will