I have a DB where i have a list of clients and links (via a hyperlink field) to various documents they have sent us.
What i am trying to do i run some filters to filter the documents and then run a report that lists the various clients and the pdfs (usually letters) they have sent us.
Query...
Apologies if this has been covered before. I have had a quick search and couldn't find a thread with my exact problem.
The thing is I have a table with a primary key, as you should, but say I add 10 records which then have primary key values 1,2,3,..., 10 and then delete the records with keys...
I have an Access 2016 database on a server which has between 5-10 people using it at a single time. However ONE user and ONE user only keeps killing the database and getting the message "Microsoft Access has detected that this database is in an inconsistent state, and will attempt to recover the...