Search results

Thanks, Pat, for the speedy response. As I posted a few minutes ago, I had a flash of inspiration, and decided to check the Primary Key. It was not set for the Permit Number field of the table. Re-assigning the key fixed the problem. Something so simple, but easy to overlook.

Never mind, I found the problem: The Primary Key, which was assigned to the Permit Number field, was removed. Don't know how, because it was there in Office 2007, but not in Office 2010.

I work for the City of Charlotte, NC, Dept of Transportation. We created a simple Access DB 10 years ago to issue Permits to occupy our street Rights of Way for periods of time greater than 30 minutes and less than 24 hours. Our main table, rightly or wrongly, contains 12,000+ records, each...

Hi folks, I'm located in Charlotte, NC, and work for the Charlotte Dept. of Transportation (CDOT). We use MS Access for tracking some of our Events, Parades, and Arena Events in the uptown area. My little chunk of CDOT is responsible for reviewing construction plans and issuing Permits for...