Search results

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...

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...