Search results

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