You might have more luck with replies if you posted in the Databases forum :)

I'm using Access 2003 and it has converters to and from older versions like 2000/97. Have you looked into those?
...

Oops, you're right DLH, I misread it.

I don't know of any 2002>2000 converter either.

Yes. :)

I'm using Office 2003 on Win2000, all works fine. I upgraded from Office 2000 and it went very well--just needed to check the settings in the various programs' Tools > Options panels and...

I would suggest letting Access do its own thing with an auto-number primary key. Your next three fields are date, building# and problem#.

For your staff to enter their inspection data, use a...