Recent content by Shimon

Hi, I inherited a Database written in a Right To Left Language. It was written by a programmer who has no formal training, and therefore has several basic design flaws. As it is written in Right To Left and the code is Left To Right, I find it very hard to understand and follow the code...

Hi, I tried to refactor the DB so that the main table names and columns would be in English, so that I can show a screenshot. The First attempt took about 3 hours and failed. The second attempt took about two hours and failed on a stupid calculated field. I say stupid, as in my humble opinion...

Thanks all for your input. I spent a few hours creating a set of queries to copy all the tables, delete the data from the original ones and append the original data from the copied tables back into original ones, after creating the necessary PK and relations. I then removed part of the...

I'll try, but I don't know if I'll get to it until next week.

Hi, I'm not really an Access developer, but took up the responsibility for implementing changes in an existing Access database. I do have previous experience writing "raw" applications in Access and served as a Data Administrator (not DBA) in a big project. The application is for a Non-Profit...

Do you have a breakdown by Country? My site got loads of hits from China. Irrelevant what my opinion of them, this doesn't count for me. Shimon

Hi, I would suggest having the MariaDB tables as linked tables, name them lnktTBL1, lnkTable2 etc. Create a duplicate set of tables names Table1, Table2 having the same structure. Upon startup run a Delete query on Table1 and Table2 and then have an Insert (update?) query that copies all data...

Hi, This is what I found. If you install an SQL Server Express somewhere in your network, you can share all hosted databases with all users in your network... there is no limitation based on the number of users, only in size and compute power. Sincerely, Shimon P.S. I couldn't add the link...

Hi, I downloaded the example app and tried it on a file created and updated by Enterprise Architect. This is a UML oriented analysis and design tool. The file format is ( at least in older versions of EA) an Access format. I changed the file extension from eap to mdb and opened the file in...

Is this a DB that you created? If not, maybe this is relevant: within Access, Forms, Reports and Queries have a RecordLocks property that controls how the underlying data is locked. Setting this to "No Locks" (0) should mean that optimistic locking is used, and two or more users can edit the...

Hi, In DB2 there is a setting of how many rows get locked at a time. I just looked this up and found that this is possible in SQL Server, as well. There several adverse aspects in playing around with these settings without knowing what you are doing, but it may be a possible solution for your...

Thanks Doc. I found that thread and started reading it. In general, I try to keep politics ( and religion) out of my workspace conversation. Shimon

Hi, I'm Shimon from Jerusalem, Israel. I'm an Access user from about 1995 (dabbled in DOS based db program, before that). I wouldn't call myself a programmer, as I've done very little programming. The last 20 years, I've been involved mostly in the SW engineering world, teaching and coaching...