Anyone remember if A97 append query failure would ever report
data breaking validation rule when such was not the case. I have
an old SQL statement - several years old now. I've encountered
a case in which the append fails and the reported error is validation

SAN Database Management
Discounted IP SAN solutions. Switch to SAN, get offer details.
http://www.healthhuman.com.cn/Database-Management.htm
Database Management Courses and Schools

That rather long subject says it.
In Access97 running on XP - I want to display a Maximized size Form01, then
open a Restore size Datasheet View Form02 on top of the first Form.
PopUp won't give me Datasheet view.

The application was built in Access 2000 and upgraded to Access 2002
and currently runs on desktops with Access 2002, 2003 and 2007 in
multi user environment.
The MDB file executes the expression fine without error yet the MDE

I've read that one method of repairing a misbehaving database is to
save all database objects as text and then rebuild them from the text
files.  I've used the following code posted by Lyle Fairfield to
accomplish the first step:

I've got a form which logs various issues.
What I'm after is a blank version of this form where I can input data.
Then hit a button and it finds all records with that data.
I remeber doing this at uni a few yrs ago - but typically, in the

Hi, Is this a stupid question?
Senario: Two tables linked together with an ID number.
Question: When using a combo box, which refences another table by
indexed autonumber, is there a way to copy the returned text value to

Sorry if this is a repeat. I'm posting this on 3 newgroups.
I'm trying to write a small app for my wife's chiropractic
business.   She needs a list of patients, schedule and a way to print
insurance forms with codes.

Office 2007 & thus Access has had it's menus replaced with the Ribbon
Bar. It's very disconcerting. In Word, Excel, Access, I feel totally
lost. Also all the shortcut Menu pulldowns don't work anymore ...
eg

One of the users in our departmental db has Read/Write permissions to a
particular form.  He was able to access and edit the form at will until 2
weeks ago.  His current problem was that he was not able to edit the data
(no message ever appeared telling him he could not change ...

Using Access 2000, is there a way to sort on multiple fields at the same time.
Here's what I want to do: I have a simple, three field database of CD's. The
fields are ARTIST, ALBUM and CATEGORY. I know I can sort any one of the fields
by itself. What I'd like to do is sort the ...

Convert them to CSV in Excel, then use TransferText (which does not
work correctly and also doesn't accept XLS/Excel files directly) or
create a link to an Excel XLS workbook and do an Append Query (as some
have suggested here)??

I have a continuous form that has one combo box (cbo1) with the
selectable values of "Removal" and "Installation". I would like to
change another combo box (cbo2) value list based on the selection in
cbo1.

I have 2 Access 2003 databases that are exhibiting the same problem.
These are frontend databases with tables linked from a backend DB. The
problem only manifests under Windows Vista.  All is good under Windows
XP.

I want to sum all values in the profit field of table T and write it
to Table Sys.
I have instantiated object d as a DAO database object and various
other UPDATE queries are running fine, but only when I calculate from