ms-access-2016 Archives

[Solved] Multiple table update design in Access

January 18, 2023 by Kirat

As from the comments, this is what I’m thinking of when I read your description: Since the UpcomingGames will be entered first and exactly one GameResult can be entered per UpcomingGame, this will be a 1:1 relationship. As the name Upcoming says: The Upcoming data has to be entered before the Result can make sense. … Read more

[Solved] System.Data.OleDb.OleDbException: ‘Invalid SQL statement; expected ‘DELETE’, ‘INSERT’, ‘PROCEDURE’, ‘SELECT’, or ‘UPDATE’.’ in my Accounting Project

October 1, 2022 by Kirat

Typo of select in OleDbDataAdapter da = new OleDbDataAdapter(“Selct * from [Product]”, con); That should be like OleDbDataAdapter da = new OleDbDataAdapter(“Select * from [Product]”, con); 1 solved System.Data.OleDb.OleDbException: ‘Invalid SQL statement; expected ‘DELETE’, ‘INSERT’, ‘PROCEDURE’, ‘SELECT’, or ‘UPDATE’.’ in my Accounting Project