Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ClemsonSeth

    Query to count duplicates and non duplicate

    Access has a really easy query wizard for finding duplicates in a table. This will get you part of the way through your problem without any code. Try this: With Access open to your queries window, look at for a button that has the icon for a new query (different from the 'Create query by using...
  2. ClemsonSeth

    Table loses primary key setting

    Mark: Not sure that I have found a solution, but I have found some more info on the subject. Follow the link below - it is a bit confusing, so here is my interpretation of all of it...
  3. ClemsonSeth

    Table loses primary key setting

    There are no Make-Table queries. I do have lots of 'append' and several 'delete' and one 'update'. -Seth
  4. ClemsonSeth

    Table loses primary key setting

    Hello: I've got an Access database running on a server with 10 or so users. In the last couple of days, I've had a probem twice that I was finally able to diagnose as a table having "lost" a primary key setting. The autonumber field that I had designated as the PK was no longer set as a PK...
  5. ClemsonSeth

    shared access error

    Under the Tools menu, choose Options, then the Advanced. Make sure that the default open mode is set to "shared" not "exclusive". Also, If any user is working in a table, it can cause problems for other users trying to work on info in that table - so you'll need to make sure that your users are...

Part and Inventory Search

Back
Top