Ok so I did that and now...
This was my code for connecting to my access data base and it was working but now that its being used with the advanced hmi stuff i get an error that says
"The Microsoft.ACE.OLEDB.12.0 provider is not register on the local machine"
'' Sets value for dbProver, dbSource, And con.connectionstring
Try
dbProvider = "Provider=Microsoft.ACE.OLEDB.12.0;"
dbSource = "Data Source = C:\Users\jessedmcneely\Documents\Access Databases\FurnacePrograms.accdb"
con.ConnectionString = dbProvider & dbSource
''Opens connection to database
con.Open()
''Selects all data from database
sql = " SELECT * FROM FurnacePrograms"
''Set Da as new DataAdapter uses variale sql to sends to con
Da = New OleDb.OleDbDataAdapter(sql, con)
'' Fills the Dataset with the data from the database via DataAdapter
Da.Fill(ds, "FurnacePrograms")
''Closes DataBase Connection
con.Close()
''Counts rows in the dataset and sets MaxRows equal to the number of rows
MaxRows = ds.Tables("FurnacePrograms").Rows.Count
''Sets inc equal to zero to load first program on startup
inc = 0
''Calls Sub NavigateRecords
NavigateRecords()
''If any of the previous steps could not be accomplished it will throw an error message
Catch ex As Exception
MsgBox(ex.Message)
End Try