Recent content by tmaccabe

Do you think record locking would help, or any other changes from default settings?

I have not looked for records with negative IDs. If I find one it indicates a record not updated? Is this only for new records?

Clear Cache On Close is not enabled.

It's like the user leaves the record and comes back and their changes are missing.

Oops

Sorry guys, brain fart there on bound unbound. Talking bound forms.

My users are occasionally experiencing data loss in their bound forms linked to SharePoint Lists. Caching is enabled for v2010 and later. Advanced Client Settings are default and shared with no locking and with default encryption. Form Recordsets are Dynaset. I'm guessing that our connection...

Can you explain why/how Access queries are faster connected to Azure SQL that they are with a SharePoint List or DV table? It seems that both a List and a DV table are cached solutions, so I'm sure that's part of it. But I don't know why.

Just a small Hobbit in a big world, learning to work with what I have. I'm going to have to learn Power Apps.

Been doing some testing with an Access table of 60k rows. It took roughly about 45 min (each) to upload this table to both a List and a DV4T table. After an initial 2-3 minutes to cache, select queries on these were equally responsive. Copying one text column to another (for all rows) required...

Thanks George. For all the talk of scalability, a cached set of tables will just get slower and slower the bigger they get. So is DV scalable for Access, not so much. Seeing that CData ODBC driver sure gave me hope that MS would provide the same. I’m running lists that I expect will grow to...

Just tested, in the Access Query Designer, if you create a query of a Dataverse table, press Pass-Through, and then Run, it pops-up an ODBC data source selector. This implies the Microsoft connector is not ODBC. Bummer. Isn’t that just like MS? Advertise an ODBC layer, and then not make an...

I'm talking about linked tables with Dataverse tables as the source.

I've learned enough about building and querying SharePoint lists to be dangerous. It's all about the cache and its size, and whether you are updating many rows. It's also about understanding the impacts of changing list settings and of dropping new front-ends while users are connected. The...

One approach to ensure that a FE isn't inappropriately opened/replaced/deleted on a network share is to ensure that no one but admin has modify permissions to its folder. Permissions for the BE location must include modify, so hide this LAN/WAN location as best you can. I popup a message (and...