Simon Mourier's Avatar
Simon Mourier's blog (1807 answers on StackOverflow) about Microsoft technologies C#, C/C++, .NET, WinRT, WinUI3, AOT, P/Invoke, COM, Interop, DirectX, Direct2D, Windows, ...
  • 🔎︎ Search
  • Categories
  • Archives
  • About Me
  • c#
  • errors
  • sql

OleDbException when doing INSERT in .mdb database

Jul 2, 2013 See the question and my original answer on StackOverflow

Interval is a keyword for Jet/Access, change your command into this (surround Interval with brackets):

OleDbCommand sql = new OleDbCommand("INSERT INTO Schedule (BackupID, Repository, [Interval], Type) VALUES (@BackupID, @Repository, @Interval, @Type)", conn);
  • SmoBlog © 2010-2026 Simon Mourier. All rights reserved.
  • Privacy & Terms