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

Post a Comment

Popular posts from this blog

ios - MKAnnotationView layer is not of expected type: MKLayer -

-
Image
so code works fine logger riddled message. there way rid of or suppress it? postannotation.swift class postannotation: mkpointannotation { //mark: properties let post: post //mark: initialization init(post: post) { self.post = post super.init() self.coordinate = cllocationcoordinate2d(latitude: post.latitude, longitude: post.longitude) self.title = post.title self.subtitle = post.timestring() } } adding annotation let annotation = postannotation(post: post) self.map.addannotation(annotation) func mapview func mapview(_ mapview: mkmapview, viewfor annotation: mkannotation) -> mkannotationview? { if annotation mkuserlocation { return nil } var annotationview = mapview.dequeuereusableannotationview(withidentifier: "pin") as? mkpinannotationview if annotationview == nil { annotationview = mkpinannotationview(annotation: annotation, reuseidentifier: "pin")
Read more

ZeroMQ on Windows, with Qt Creator -

-
i have installed zmq link given below on windows 7. http://zeromq.org/distro:microsoft-windows 1) have c++ project in qt-creator , i'm using zmq c++ binding (zhelpers.hpp etc). 2) have added .lib installed zmq folder qtcreator 3) while compiling, compiler looks _imp__zmq_verion, in .dll files present in .lib have __imp_zmq_version. 4) causing undefined reference zmq_version. anyone else faced problem , has solution ?
Read more

unity3d - Unity SceneManager.LoadScene quits application -

-
i have 2 different scenes 1 named 'main' , other 'game' both added scenes in load. when use scenemanager.loadscene("game"); works no problem when tried return main scene code if (input.getkeydown (keycode.escape)) { scenemanager.loadscene("main"); } strangely game quits. thanks. sorry interruption. somewhere on other script found code. if (input.getkeydown (keycode.escape)) { application.quit (); } that's bad, know...
Read more