Search results

Thanks for all information. I didn't get any errors. The only probles was that when I try to open form all computer was very slow. You can see it when you move mouse coursor. As I remember after 1 hour it will open form. It was very strange for me because another form with subform works. I...

Updated: It's very strange but I think I fix it a little. I open form in designer. Delete and add the same subform and it starts working. It's not as fast as in normal computer but after 1 minute it opens form. Before after 30 minutes nothing happen.

It's strange because I created all forms about 8 years ago and in production with shared folder it work ok. Only in this 2 laptops I have problems. I will check it but it only show data connected by vat_number from another table.

Ok. I find where is problem. In this 2 forms that I can't open. There are also subforms. I think that it's because Windows 11 and maybe a something else because with Windows 10 I think it works on laptops. In form 1 I have one subform with connected data. when I delete this subform it starts...

I think about that but in my opinion it can't be that. Of course normal computers has better disk experience but not bad. I add cristaldiskmark information. Program is connected with 6 databases database1 = 100MB database2 = 32MB database3 = 68MB database4 = 24MB database5 = 204MB database6 =...

Hi, I have very strange situation with my program. I have the same program loccaly with backend and fronted in 4 computers. In all situation databases are in the same computer. 1. Normal computer Windows 10 64 bit, Ryzen 5800X, 16GB RAM, Microsoft® Access® 2019 MSO (wersja 2408 kompilacji...

Ok I have a solution. QNAP has problem with samba. You can install your own samba controller in container and it works very fast. So finnaly it's possible to use QNAP but better option is to buy server with Windows Server where aren't any problems.

I find interesting thing in QNAP. When I tick "oplock" in SMB properties it works very fast. So the problem is when it was disabled. QNAP has problem with sharing files with that option disabled.

No. I program in PHP with frameworks and .NET.

I add week number and year to get it work faster. Where is it possible I use this two than date but I can't use it in all reports. Here is about 80% tables. This table Umowy has 70 columns and 30 000 records, but the biggest tables is Tabela splat and NotaOdsetkowa (each about 1 500 000...

I think I have some problem because I created it about 10 years ago for the temporary program but it works till now. I create a lot of new functionality and there ale a lot of changes in company so I know some problems but without create all new program I didnt have idę to optymalize that. I...

It's not possible to store it in one table. There are a lot of tables where data is very important and i must choose information from this table to one raport. I made a lot of improvements, but it hard because there are a lot of important data in one raport. This system is like bank credits...

I will check it but in my opinion it's not problem with memory because all PC in my opinion is quite power. Ryzen 5650 with about 16GB DDR4 memory 3200MHz. When it works with windows server it's a lot of faster (x10). Windows server has only one ethernet port 1GB. New QNAP has 2 ports 2.5G and...

Of course all users has their own copy localy on Windows 10 Pro. So there is 6 frontend and shared backend databases (7 databases, because i split big databases separetly to speed it). Two years ago I have another idea. Buy Windows Server with shared windows on them. In this case everything...

I try this another idea. I mount iscsi to Windows Server 2012 and share this disk to another users. It seems that i get about 30 secounds.

Ok i try this. Thanks I use QTS Hero with ZFS. System is on 10TB Raid and SSD M.2 as cache read/write. Disk read is about 3430MB/s and write 2600MB/s. I can also change it and reinstall system on SSD without cache. Also 32GB of ram in my opinion is ok with this database size. I think I need...

Hi, I have quite big database in MS Access and has some problems. Introdution: I have 7 databases backend (.accdb) located in shared folder in Windows Server 2012. Each database is about 80-200MB. From this databases i created one frontend. Some tables has about 1 500 000 records. It's problem...

Hi, I'm Martin and I made quite big system in ms access. Slpit databases with frontednd and backend and about 6 databases with milon of records. I'm happy to see this forum because I have similar problems as one thread (corruption databases) and try find how to use QNAP serwer with the database...