Hi All,
I am new to this forum and am in my second year of a bsc in computing.
I am using lazarus on windows 8 64 bit(i have installed the 32bit lazarus though) i also have microsoft access 2013 that im using to create my database. have used an ODBC connection, with a sqltransaction,sqlquery, datasource and dbgrid.
I have managed to connect the database to my application by creating a dsn file and saving it in the projects folder. During design time I am able to see the data in the DBGrid(live data). before running my application I make sure i set the connection property of the ODBC connecter to false and the datasource as well. The program runs and I can see the data in the dbgrid as expected. However, I cannot edit the data in the grid(I cant delete a letter/s or change a number or anything) the cursor allows me to run through the data but cant change anything.
I cannot figure out why it wont allow me to do anything.
Even when adding a DBnavigator, none of the buttons where activated after selecting a datasource.
Please can someone help. I have to submit an assignment and am running out of time.
Thank you