I find the answers to this question to be problematic, confusing and incomplete, so I’ll make an effort to do better. Q1: How can we make sure that the write-user can make changes to the table data while other users use the data? Do the read-users put locks on tables? Does the write-user have to … Read more
Take a look at this very thorough list of reasons why recordsets are and aren’t updateable: When Recordsets Are Always Updateable A recordset is always updateable when: It is based on a single table. It is based on a query based on a single table. It is based on a query based on tables with … Read more
You need to use Option Explicit at the top of each VBA code module including forms and reports. You can set this for all future created modules and VBA code behind forms and reports by going into the VBA editor >> Tools >> Options >> Editor tab and ensuring Require Variable Declaration is checked. From … Read more
It’s mainly a matter of history, effectively ACE has superceded JET: Wikipedia answers your question in great detail. The most relevant sections are: With version 2007 onwards, Access includes an Office-specific version of Jet, initially called the Office Access Connectivity Engine (ACE), but which is now called the Access Database Engine. This engine is fully … Read more
yes and no. You can’t do: insert into foo (c1, c2, c3) values (“v1a”, “v2a”, “v3a”), (“v1b”, “v2b”, “v3b”), (“v1c”, “v2c”, “v3c”) but you can do insert into foo (c1, c2, c3) select (v1, v2, v3) from bar What does that get you if you don’t already have the data in a table? Well, you … Read more
The above design requires four subforms. Each subform should be based on the junction table with book id as the link child and master field and a combo box based on the relevant table for the second table id. For example, your first subform is Authors, the table it is based on is Libri_Autori Link … Read more
To build on Ilya’s answer try the following query: SELECT MSysObjects.Name AS table_name FROM MSysObjects WHERE (((Left([Name],1))<>”~”) AND ((Left([Name],4))<>”MSys”) AND ((MSysObjects.Type) In (1,4,6))) order by MSysObjects.Name (this one works without modification with an MDB) ACCDB users may need to do something like this SELECT MSysObjects.Name AS table_name FROM MSysObjects WHERE (((Left([Name],1))<>”~”) AND ((Left([Name],4))<>”MSys”) AND ((MSysObjects.Type) … Read more
It is a very bad idea indeed to name anything Name. It seems to me that you need cascading comboboxes. You will need a little VBA. Two combo boxes called, say, cboLocation and cboNodes, on a forrm called, say, frmForm cboLocation RowSource: SELECT ID, [Name] FROM Locations ORDER BY [Name] ColumnCount: 2 ColumnWidths: 0;2.00cm ”The … Read more
Causes General error Unable to open registry key Temporary (volatile) Ace DSN for process … This is the top-level error message produced by the Access Database Engine (a.k.a. “ACE”) ODBC driver when the current process is unable to open the Access database file for one of the following reasons: Some other process has opened the … Read more
Access 2010 has both stored procedures, and also has table triggers. And, both features are available even when you not using a server (so, in 100% file based mode). If you using SQL Server with Access, then of course the stored procedures are built using SQL Server and not Access. For Access 2010, you open … Read more