FYI
I am using this VBA code to update the table through a form
Dim strSQL As String
strSQL = "INSERT INTO Product(ProductName, ProductQty, ProductSupplier, MinimumStk, ProductLocation, ProductShelf, ProductDrawers, ProductUnit) VALUES ('" & Me!ProductName & "','" & Me!ProductQty & "','"...