I have a new database with about 20 SQL tables. I linked them to Access 2007 and I can open all the table and change the data except for 1. The one table I can't edit is my main table and is linked to 12 of the other tables. Is there a limit? I was able to add a record but as soon as I left the record and tried to edit it I get the error Write Conflict...Save (greyed out) Copy to Clipboard or Drop Changes. Why just this one? I've tried deleting the link and relinking with no luck.
More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.
In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.
The problem with sub-reports and headings:
Add a dummy group to the sub report using the expression =1:
Set the “Repeat Section” property of the dummy…