SP3 Issues

[stucampbell]

I created a database in Access 2003 which worked fine for months.

My IT department installed Office SP2 on my machine and now I can't enter
any data into the table which underpins my database. The queries, forms, etc
all still work fine but when I try and enter data I get a bleep. I have a
second PC which doesn't have SP2 installed, just basic Access 2003 and the
database still functions fine on this one.

They've tried upgrading to SP3 but still with the same problem.

One thing that may or may not be relevant, on the the non-SP3 machine when I
run the continuous form there's a row at the bottom which is blank and you
can move around the records. On the SP3 machine there isn't.

Same login, etc. The database is stored on a share drive.

Any ideas? It's driving me mad

 

[Dale Fye]

Stu,

I'm not aware of any problems caused by 2003 (SP2). However, there are a
couple caused by SP3. See Allen Browne's site
(http://www.allenbrowne.com/tips.html) for several issues.

 

[Tom van Stiphout]

On Wed, 19 Dec 2007 05:03:00 -0800, stucampbell

The absense of a "new record" line indicates the query or form
properties are readonly. Check that out.

-Tom.

 

[Pat Hartman]

Something has made the database not-updatable. Are you accessing the same
physical file from both PC's. the only thing I can think of that might
cause this is a change in your permissions for the drive. Make sure that
you actually are attempting to access the same physical database with the
same network logon.

 

[carol]

On Wed, 19 Dec 2007 05:03:00 -0800, stucampbell

The absense of a "new record" line indicates the query or form
properties are readonly. Check that out.

-Tom.

 

[carol]

On Wed, 19 Dec 2007 05:03:00 -0800, stucampbell

The absense of a "new record" line indicates the query or form
properties are readonly. Check that out.

-Tom.