I have used this trick in versions of Access up to 2003 - I haven't tried in 2007 though.

Go onto a machine that works normally, open the Access database....

When I set up an Access to SQL system over the internet a couple of years ago I had the help of a network engineer who did the firewall config...

I have previously been able to set this up between Access 2003 and SQL Server 2000 across the internet using ODBC. Had no trouble with forms etc. that has been...

Sure - generic question, generic answer.. Try zipping it, whatever 'it' is!

Has anybody written a VBA function called IsMonthOK() in the original Access mdb?

I had something similar in Access 2003. My solution was to add one of the following lines of code to my button:

Forms![myformname].refresh

or

Forms![myformname].requery

Well said John. I definitelty agree. My children will both have opportunity to go to university if the want, with gentle encouragement from me!

So what I am saying is that...

I have no degree, my parents could not afford it. My father kept the family together as best he could as the sole wage earner. After age 18 I was...

I see it as a question of diversity.

It is ok to be extroverted / introverted / young / old / black / asian / white / male / female...

Can you post the relevant section of your VBA code, and any info about the table that is failing to insert rows, e.g. primary key, any constraints?

A couple of slightly off-the-wall causes I have seen before:

- The network guys had made a change to firewall configuration / internal tcp/ip routing which was noticably slowing down the...

I once had slow performance with enterprise manager, it turned out there were erros in the server event logs related to hard drive read errors.

Failing a hardware problem, try reinstalling...

Another suggestion I've seen used.. Its a bit lazy, but Access 2003 has an option to Compact on Close. Its on Tools->Options, the General tab. Whenever users close the mdb...