Recent content by nomatterwherewego

Could you elaborate or guide me to a resource for that? I quickly googled and this seems to be an interesting approach, unfortunately I'm still very new to Access and don't know immediately how to do that.

That's a good point, thanks! So just to be sure, you mean something like: Set rst = dbs.OpenRecordset("SELECT * FROM Bestellungen WHERE 1=0", dbOpenDynaset, dbSeeChanges) I just tried and changed that line, seems to do the same job. I will distribute that frontend to the users and see if that...

Sorry, some more information: I'm using SQL Server 2017, users are using various access versions (I cannot fully control that), mostly Access Runtime 2016. Orders ("Bestellungen") table does not have any primary key, but an identity column ("Laufende Bestellnummer"). Order have positions which...

Hi! I have inherited a MS access application (small ERP type system) and was asked to migrate the backend to SQL Server Express. I did and after some changes to the frontend ('dbseechanges' for columns with identity columns, ...) it works fine and fast for the most part. For one part of the...