int rowsAffected = 0;
            using (OleDbConnection connection = new OleDbConnection(Properties.Settings.Default.B3DVDkolekcijaConnectionString))
            {
                using (OleDbCommand command = new OleDbCommand(query, connection))
                {
                    connection.Open();
                    rowsAffected = command.ExecuteNonQuery();
                }
            }

                return rowsAffected;