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

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

Leave a Reply

Your email address will not be published. Required fields are marked *