Search results

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

A couple of months have passed. I'm wondering if you are still hosting front-end files via SharePoint and OneDrive that are opened via a short-cut? My understanding is that this can lead to front-end corruption (if there are multiple users sharing a file), because OneDrive and Jet are...

I'm working with a couple of lists now, one has 10k rows, another 14k. Once you're in and the cache refreshes, it's smooth sailing unless you are doing an update query impacting many rows. Bound form operations work just fine. Granted, I don't have more than a couple dozen users. It's important...

Speaking of performance, what is it like to query a SharePoint List of 100,000 rows? I guess it's fine as long as your cache is up-to-date? I imagine loading the cache is the long part. How does this differ when linking to DV? Is caching the same? Are queries processed locally or can you do pass...

Not sure why the site wouldn't let me post this reply? Bad content or spam-like? I don't see it. How to avoid? Maybe that's a question for another thread. This one is about having a forum for SharePoint as it relates to Access, correct?

My experience linking Access to a Document Library is that I couldn't update the libary without error. I could read it just fine, but not write to it. I haven't tried using VBA to edit a Document Library. Perhaps if it's sync'd to OneDrive you could use the File System Object? No idea. Didn't...