My experience with MS Access is similar in that it doesn't do well with multiple users. You're better off using an RDBMS that was designed for multiple users. In the US, hospitals have legal requirements for storing and protecting patient data. I would take local regulations into account when picking out an RDBMS. Cost being one of the lower priority requirements. Row Level Security (RLS) would be high on my decision matrix. IIRC - MS Access front end can connect to MS SQL (Express) RDBMS. It might be able to connect to other RDBMS via ODBC. So, all your UI work may not have been lost. As you grow, you'll have multiple applications interacting with the data. You should plan on that happening. I do this by putting most/all of my data logic in the database (stored procedures, etc). The front-end technology is then chosen based on how easy it can handle this type of design. Beyond that: "Which RDBMS should I use?" is off topic for this site.

What is the relationship between table 1 and table 2? Is it one-to-one based on ID? There are two ways you can do this. Either: Create a query with ID, RegDates, CatName1, CatName2, DogName1, DogName2 using the query builder or with the following SQL code, and then use that query as the Record Source of the Form: SELECT Table1.ID, Table1.RegDates, Table1.CatName1, Table1.CatName2, Table2.DogName1, Table2.DogName2 FROM Table1 INNER JOIN Table2 on Table1.[ID] = Table2.[ID] Use a subform on the form with Table2 as the Record Source, linking its ID to the ID field from Table1 which is used as the main form's record source. In general it's tidier to do something like (1) whereby you base the form record source on a query rather than the actual table data. Hope this helps!

The code looks good. The point is: when to execute? In this case there are two events that should trigger the code: the Form_Current event for the form (showing a record) and the After_update event for the FieldProcess_Water control.

You can think of a view as a non-materialized query definition with a referenceable name. It doesn't store any data itself, rather when you query a view the data comes from the underlying entities that compose the query for which that view represents, effectively the tables that actually store the data at the lowest level themselves. The columns of a view take on the data types of the source entity they ultimately come from. DML statements can be executed against a view, such as deleting and updating data, which will cause the view to act as a passthrough of such statements to the underlying tables. But generally there are restrictions on when and how a view can be updated, for example usually only columns from the same underlying table can be updated in the same statement against a view. While I couldn't find a direct reference to these restrictions in MS Access, you should be able to find somewhat helpful information on the same restrictions in https://docs.microsoft.com/en-us/sql/t-sql/statements/create-view-transact-sql?view=sql-server-ver15#updatable-views in SQL Server which parallels MS Access to a degree.

Nothing wrong if you need a monthly sales analysis, it's gonna be one of the aggregating functions or COUNT or SUM And the code will work normally. If it only works, if the date matches completely, then it's not the right thing to do for a month. I don't remember MS-Access, and in PostgreSQL, this will look as follows:SELECT month, COUNT(*) FROM art --Или SUM(fieldname) JOIN LATERAL EXTRACT(MONTH FROM дата) month ON TRUE --Просто чтобы не писать то же самое в GROUP BY WHERE дата IS NOT NULL GROUP BY month ORDER BY month Well, if it is. Наименованиеnaturally, the records will not be 12, but will depend on the number of different names sold in the month. Although, if Delphi makes it even more comfortable, there's a group in the tabloid to do months and it's gonna be nice to turn around every month with a sum of money. footer

Challenge app.CurrentDb().Name creates a controlled COM target dao.Databasethe reference to which no reference is retained, so it cannot be released at any later time except as a finalist. As a result, the programme keeps the base even after the challenges. app.CloseCurrentDatabase() and Marshal.ReleaseComObject A second copy of the facility. Challenge GC.Collect() It's not helping, because the finaliser's not being performed immediately, but only after a while.In order to make the base perfectly clear, we need to get rid of a second copy of the facility (as it is not necessary):dao.Database db = app.CurrentDb(); string pathToDb = db.Name; string pathToCompact = Path.Combine(Path.GetDirectoryName(pathToDb), Path.GetFileNameWithoutExtension(pathToDb)) + "_compact" + Path.GetExtension(pathToDb); app.CloseCurrentDatabase(); Marshal.ReleaseComObject(db); app.CompactRepair(pathToDb, pathToCompact, true);

Create a base profile in the OBD table. And by doing that, to form SQL requests. For example, we' a table info on the tables.CREATE TABLE info ( ID int identity (1, 1) primary key ,NameTable varchar(50) ,NameColumn varchar(50) ) When the annex is launched, we shall read this table and ask for other tables. For example, we download the table to DataTable with the name infoTable:string command = "SELECT [ID] "; foreach (DataRow row in infoTable.Rows) { command = command + ",[" + row[2].ToString() + "]"; } command = command + " FROM [" + row[1].ToString() + "]"; Ultimately, the command receives a type request:SELECT [ID], [NameColumn1], [NameColumn2] FROM [NameTable] And so on... The table in the OBD system is changed, the description is changed, the queries are developed differently.

We can write a VB function that will glue the line. Details can be read: http://hiprog.com/index.php?option=com_content&task=view&id=334&Itemid=35 Body of function:Public Function UnionStr1(ID, Fam) Static IDOld, FamUnion If IDOld <> ID Then IDOld = ID FamUnion = Null End If FamUnion = (FamUnion + ", ") & Fam UnionStr1 = FamUnion End Function Example of request:Select ID, Last(UnionStr1(ID,Fam)) AS FamUnion FROM Tab1 GROUP BY ID; There's an interesting way in the same article. Only ms-access sql with an intermediate table. Although it is possible in your case that her role will be played by the Person(s). It looks like,Метод 3. Заполнение таблицы при помощи запросов (по Митину). http://c85.cemi.rssi.ru/Access/AnsPointDetail.idc?QID=14147 Оригинальный и неочевидный метод. Выполняется с помощью двух запросов. Запись в Tab2 уникальных ID без фамилий. Текст запроса WriteID: INSERT INTO Tab2 (ID) Select DISTINCT ID FROM Tab1; Запись списков фамилий. Текст запроса TabUnion5: UPDATE Tab2 INNER JOIN Tab1 On Tab2.ID = Tab1.ID Set Tab2.FamUnion = ([Tab2].[FamUnion]+", ") & [Tab1].[Fam]; Оценка скорости: по-видимому, работает быстрее метода 1 за счет отсутствия вызова специальных функций. Недостаток: "Однако в T-SQL это непрокатывает" (Митин). We need to balance, it looks interesting. UPD:The point is, it's about "fucking." ms-access SET will be performed as many times as the records in the attached table (not the one that will adapt). Because of "smart" T-SQL♪ T-SQL This way will not work.By the minus of this way, I would add the need for escorts to the new version. access♪ If MS They're going to get a little closer. ms-access to standard ANSI-SQLthat method might stop working.On the other hand, maybe they'll do something to conquer the lines: Although that is even the case MS SQL Server I'm still paying attention. MySQL♪ PostgreSQL♪ Oracle It's a long time ago.

Erroneous report on an unification request containing more than one association for complex data tables: "The target is not found by the Microsoft Office Access nucleus."The following erroneous report may be displayed in adding the investment field to the table: { The object has not been found the core of the Microsoft Office Access database. Check the existence of the object and the correct name and path. ♪ This error occurs when a request for integration is in the field with more than one association for complex data tables.Acceptance https://support.microsoft.com/ru-ru/kb/942378 p.s. I think the problem with the names of the columns seems like

As far as I know, there's no full-time interface to create a user-friendly aggregation. It is possible to use bypass roads for this, the type of transfer of all SQL the function, but the speed of work will be much lower than the standard. http://www.pcreview.co.uk/threads/writing-custom-aggregate-functions.3491184/

You need two subforms in uniform. One contains your records, and the other contains the same records, but with the filter on the assigned value of the first form Nominal.

You need to share display and editing.The challenge of display can be accomplished by one. Queryof which SQL Request issued with INNER JOIN♪The task of editing is somewhat more complex. With help, again, the only one Query relevant data can be displayed. Under certain conditions, even the same can be used. Querywhich serves to show. To make changes better Command requests INSERT♪ DELETE or UPDATE (depending on the task).However, in any case, the code will have to be written for editing, as Query does not automatically compute data to related fields and therefore cannot correctly edit the data set from several associated tables.It still needs to be edited right in the hybrid.This is very difficult to implement. At least with standard components from the box. At least because:As stated above, Query It will not understand what and where to add in the case of external keys;Standard DBGridhas a very modest function. The best thing you can do is do it. Simple Disgusting textual List PickList♪But you can try to find other, more functional, components. Like EhLib.

I can suggest another option: the BatchAccess steer can import into MSAccess from the CSV file. https://rsdn.ru/article/files/progs/BatchAccess.xml There's a originator too (C#), so you can finish up to the right functionality.

SELECT Dolzhnosty.Kod_dolzhnosty, COALESCE(T.kolichestvo_sotr, 0) as kolichestvo_sotr, COUNT(*) as kolichestvo_zakazov FROM Dolzhnosty --LEFT нужны для того, чтобы не потерять должности, у которых нет сотрудников --или есть сотрудники, которые не формировали заказы. LEFT JOIN ( SELECT Kod_dolzhnosty, COUNT(*) as kolichestvo_sotr FROM Sotrudniki GROUP BY Kod_dolzhnosty ) as T ON Dolzhnosty.Kod_dolzhnosty = T.Kod_dolzhnosty LEFT JOIN Sotrudniki ON Dolzhnosty.Kod_dolzhnosty = Sotrudniki.Kod_dolzhnosty LEFT JOIN FormirovanieZakaza ON FormirovanieZakaza.Kod_sotrudnika = Sotrudniki.Kod_sotrudnika GROUP BY Dolzhnosty.Kod_dolzhnosty

No standard tools. The necessary field may be placed in the heading of the form, and then it will be displayed as one column and modified (or not) when switching on the notes ♪

SELECT [Тема экскурсии], COUNT([Номер зала]) AS [Count-Номер зала] FROM( SELECT DISTINCT Экскурсии.[Тема экскурсии], [Залы галереи].[Номер зала] FROM [Залы галереи] INNER JOIN (Картины INNER JOIN (Экскурсии INNER JOIN [Содержание экскурсий] ON Экскурсии.[Код экскурсии] = [Содержание экскурсий].[Код экскурсии]) ON Картины.[Код картины] = [Содержание экскурсий].[Код картины]) ON [Залы галереи].[Номер зала] = Картины.[Номер зала] )as T GROUP BY [Тема экскурсии]

This is a standard database mechanism, a unique index. Formulate such an index, and the base will give you an exception in an attempt to duplicate.Other ways are wild colts and they should not be used.

There's a solution. Simple solution to change ALTER PROCEDURE [dbo].[sproc] @param1 int, AS SELECT * FROM Table WHERE ID = @param1 ♪ ALTER PROCEDURE [dbo].[sproc] @param1 int, AS DECLARE @param1a int SET @param1a = @param1 SELECT * FROM Table WHERE ID = @param1a https://stackoverflow.com/a/13823047/4269118 But the problem is deeper and related to ADO and SQL Server. You can study it. http://www.somewheresomehow.ru/fast-in-ssms-slow-in-app-part1/ ♪

Try this:[dbo].[mytablename].[mycplumnname] = cast([Введите сюда значение:] as nvarchar)

Only Update, the relaying bases of Danes have the notion of transactional integrity, which is why it does not alter data for the summer, so it is possible only in one request.