{"action":"created","issue":{"url":"https://api.github.com/repos/linq2db/linq2db.LINQPad/issues/10","repository_url":"https://api.github.com/repos/linq2db/linq2db.LINQPad","labels_url":"https://api.github.com/repos/linq2db/linq2db.LINQPad/issues/10/labels{/name}","comments_url":"https://api.github.com/repos/linq2db/linq2db.LINQPad/issues/10/comments","events_url":"https://api.github.com/repos/linq2db/linq2db.LINQPad/issues/10/events","html_url":"https://github.com/linq2db/linq2db.LINQPad/issues/10","id":317434269,"number":10,"title":"Incompatibility with a particular Microsoft Access Database.","user":{"login":"s9596362","id":32390470,"avatar_url":"https://avatars2.githubusercontent.com/u/32390470?v=4","gravatar_id":"","url":"https://api.github.com/users/s9596362","html_url":"https://github.com/s9596362","followers_url":"https://api.github.com/users/s9596362/followers","following_url":"https://api.github.com/users/s9596362/following{/other_user}","gists_url":"https://api.github.com/users/s9596362/gists{/gist_id}","starred_url":"https://api.github.com/users/s9596362/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/s9596362/subscriptions","organizations_url":"https://api.github.com/users/s9596362/orgs","repos_url":"https://api.github.com/users/s9596362/repos","events_url":"https://api.github.com/users/s9596362/events{/privacy}","received_events_url":"https://api.github.com/users/s9596362/received_events","type":"User","site_admin":false},"labels":[{"id":338561927,"url":"https://api.github.com/repos/linq2db/linq2db.LINQPad/labels/bug","name":"bug","color":"fc2929","default":true}],"state":"open","locked":false,"assignee":{"login":"MaceWindu","id":1099238,"avatar_url":"https://avatars1.githubusercontent.com/u/1099238?v=4","gravatar_id":"","url":"https://api.github.com/users/MaceWindu","html_url":"https://github.com/MaceWindu","followers_url":"https://api.github.com/users/MaceWindu/followers","following_url":"https://api.github.com/users/MaceWindu/following{/other_user}","gists_url":"https://api.github.com/users/MaceWindu/gists{/gist_id}","starred_url":"https://api.github.com/users/MaceWindu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MaceWindu/subscriptions","organizations_url":"https://api.github.com/users/MaceWindu/orgs","repos_url":"https://api.github.com/users/MaceWindu/repos","events_url":"https://api.github.com/users/MaceWindu/events{/privacy}","received_events_url":"https://api.github.com/users/MaceWindu/received_events","type":"User","site_admin":false},"assignees":[{"login":"MaceWindu","id":1099238,"avatar_url":"https://avatars1.githubusercontent.com/u/1099238?v=4","gravatar_id":"","url":"https://api.github.com/users/MaceWindu","html_url":"https://github.com/MaceWindu","followers_url":"https://api.github.com/users/MaceWindu/followers","following_url":"https://api.github.com/users/MaceWindu/following{/other_user}","gists_url":"https://api.github.com/users/MaceWindu/gists{/gist_id}","starred_url":"https://api.github.com/users/MaceWindu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MaceWindu/subscriptions","organizations_url":"https://api.github.com/users/MaceWindu/orgs","repos_url":"https://api.github.com/users/MaceWindu/repos","events_url":"https://api.github.com/users/MaceWindu/events{/privacy}","received_events_url":"https://api.github.com/users/MaceWindu/received_events","type":"User","site_admin":false}],"milestone":null,"comments":1,"created_at":"2018-04-24T23:53:17Z","updated_at":"2018-04-28T11:54:45Z","closed_at":null,"author_association":"NONE","body":"I encountered the error message shown in the screenshot below when trying to add a connection to a particular Microsoft Access Database. The database file is attached in the Zip file below.\r\n\r\n![linqpad linq2db driver error message](https://user-images.githubusercontent.com/32390470/39175040-dd20a252-47db-11e8-80f1-7906375ce328.png)\r\n\r\nAt the \"LINQ to DB Connection\" dialog box, clicking on the Test button results in a successful test.\r\n\r\nThe accdb file opens fine in Microsoft Access 2013. LINQ2DB doesn't seem to have a problem in mapping out a database with no primary keys defined because I had a similarly structured Access Database that works great with LINQ2DB.\r\n\r\nNote: I did not design the Access database. It's taken from a third-party software. So, I have no control over its design.\r\n\r\nThe LINQ2DB LINQPad driver that I'm using is of version 1.0.52 on LINQPad v5.22.02 .\r\n\r\n[Access Database.zip](https://github.com/linq2db/linq2db.LINQPad/files/1941621/Access.Database.zip)\r\n"},"comment":{"url":"https://api.github.com/repos/linq2db/linq2db.LINQPad/issues/comments/385169525","html_url":"https://github.com/linq2db/linq2db.LINQPad/issues/10#issuecomment-385169525","issue_url":"https://api.github.com/repos/linq2db/linq2db.LINQPad/issues/10","id":385169525,"user":{"login":"MaceWindu","id":1099238,"avatar_url":"https://avatars1.githubusercontent.com/u/1099238?v=4","gravatar_id":"","url":"https://api.github.com/users/MaceWindu","html_url":"https://github.com/MaceWindu","followers_url":"https://api.github.com/users/MaceWindu/followers","following_url":"https://api.github.com/users/MaceWindu/following{/other_user}","gists_url":"https://api.github.com/users/MaceWindu/gists{/gist_id}","starred_url":"https://api.github.com/users/MaceWindu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MaceWindu/subscriptions","organizations_url":"https://api.github.com/users/MaceWindu/orgs","repos_url":"https://api.github.com/users/MaceWindu/repos","events_url":"https://api.github.com/users/MaceWindu/events{/privacy}","received_events_url":"https://api.github.com/users/MaceWindu/received_events","type":"User","site_admin":false},"created_at":"2018-04-28T11:54:45Z","updated_at":"2018-04-28T11:54:45Z","author_association":"NONE","body":"Well, I've debugged it down to https://msdn.microsoft.com/en-us/library/ms722634(v=vs.85).aspx returning E_FAIL for Indexes schema view.\r\nFor me it looks like a bug in ACE OleDb provider which should be reported to Microsoft.\r\n\r\nOnly thing we can do is to catch this error and return no primary keys in this case."}}
{"actor":{"display_login":"MaceWindu"}}