vb.net – The database has been placed in a state by user Admin on Machine X that prevents is from being opened or locked – Single User
vb.net – The database has been placed in a state by user Admin on Machine X that prevents is from being opened or locked – Single User
It seems that you can fix this issue by buffering the Access binary. Use the Binary.Buffer function in a query that defines your Access database, then reference that query in order to use the binary in a query that pulls each table. Note: I also define parameters for my folder path and file names.
For example:
//myDbBinary
let
Source = Binary.Buffer(File.Contents(DataFolder_param & FileName_param),
[CreateNavigationProperties=true]))
in
Source
// Table1 Query
let
Source = Access.Database(myDbBinary, [CreateNavigationProperties=true]),
_Table1 = Source{[Schema=,Item=Table1]}[Data]
in
_Table1
The source is this