I have created a access database (and backed it up). A glitch on my PC meant
that I had to reinstall MS Office. Now I cannot open the database (or it's
backups); error message is "Unrecognised database format". Other .mdb files
open OK.

Is it possible to have an IF and AND statements at the same time in the same
cell?
Thank you!
Larisa

I recently performed the install of Office 2003 SP3, ever since I have been
getting not enough memory errors (never ever happened prior - not once).  Is
there a known issue,  even better a fix?  
Now I can't save the work I just completed!  Oh the joy of doing a job 2, 3

I apologize if this is more appropriate for the forms group.
We recently upgraded to Office 2007, and now one of the Access databases has
a problem with being slow.  The file type is an MDE, and whenever a user
attempts to type data into a form (which represents a new record) it ...

I am using Tony Toews' Auto FE Updater version 1.74 to update the front end
of an HR-related database.  At first, I was using this for employees solely
within an HR department, and it did exactly what I wanted it to do and worked
great.

Looks like the "Default" starting Day Of
the Week is Monday.
Is there a way to to Program the Calendar
Control to start on Sunday?

I have two Date/Time (general date and time) fields that I need to calculate
the difference between the two. I'm only interested in the hh:mm:ss that have
elapsed between the two.
I've already added the field to the table (MTTR) but I will need to perform

I know folks on the board like to think that 255 is 'absurdly huge' for a
field count limit, but that just isn't true for large domains of data.  In
this case a Z/OS systems database.  An example...
NAME                 COLNO

Could anyone help with the below please???
Hi,
Thanks for the help.
Your suggestion works, but not how i want it to.

I have a picture that I want to use as a button to close the database. What
can i put in the properties/ on click to make a message box appear and ask
"are you sure you want to close?"............. obviously yes means close and
no means dont close.

I have a database which uses command buttons to input numbers into a text
box all on one form.
I can currently use command buttons to do this, however for obvious reasons
as you will see by the code, the command button will only put a number into

Would anyone have some light on this question: how critical is the
type of the field used as an index for a large database.
Let's say I have 1 million entries, every entry has a field called
"Reference" which contains a 10-11 characters string. This string is

I receive emails from a Korean customer that have a mix of English and Korean
characters, and question marks between sentences.  I am using Windows 2000
(SP4) with Outlook 2003 (SP3), at "Tools", "Options", settings are;
International Options, Encoding Options - Auto Select ...

How are you guys doing? I have a question about using SELECT and MAX
function. Say I have a Students Table with Fields StudentID,
FirstName, MiddleName, Score
StudentID   FirstName  MiddleName Score

What am I doing wrong?
Access 2007 sp1/Outlook 2007 sp1 (windows XP)
I have tried to use the Collect Data via email option.  However, I've
noticed two things which I believe are related.