MS Access and Google File Stream -


apologies in advance if dumb question, google's release of "file stream", know how impact ms access dbs stored on it?

my "setup" have users routinely using accessdb built them years ago, , i'm trying replicate in ms sql. not choice, file stored clients on google drive: means can @ vba , testing when clients not using it. clients use google's sync access file.

so question two-fold. first, if clients looking move file stream , asked how impact ability use access file (i have no idea). second, file stream make possible have multiple users on ms database without causing conflicts or problems? still need make sure have exclusive access file while making changes vba code?

thanks in advance!

the msaccess database engine fundamentally based on database primitives provided ms file system. including record read/write/lock primitives. (bet didn't know ms operating systems had native database system!).

access records , tables not filesystem records , tables, -- access database system of records , tables built on top of native system of record locking. (the native system doesn't, , never had, thing smaller file-level authentication , permissions, access built whole new system on top).

that means file system, or network file system redirector, doesn't support record locking ms file system , smb protocol, can't support simultanous multi-user access access database.

i'm not familiar google filestream, assume it's way access binary objects using database api? means api doesn't inside binary object: can't locking individual sections of file r or w or rw: means can't r part of object while else w different part: means can't share access. ... , if file stream means different google, chance support smb inside slim none, right?


Comments

Popular posts from this blog

ZeroMQ on Windows, with Qt Creator -

unity3d - Unity SceneManager.LoadScene quits application -

python - Error while using APScheduler: 'NoneType' object has no attribute 'now' -