I have only renamed the Form, Button and Label in my example.
TODBCConnection – This is under the SQLdb tab TDataSource – This is under the Data Access tab TSQLQuery - This is under the SQLdb tab TSQLTransaction - This is under the SQLdb tab TDBGrid - This is under the Data Controls tabĢ.4.3 Your screen should now look similar to the one shown below after adding all the above controls.Ģ.4.4 Add a button and a label to your form, remember to rename all your components. Wellsįor this project, we will be requiring the following: Lazarus and MS Access DB on Windows 7 64-bit8 of 10 Christopher W. WellsĢ.4.2 A screen similar to the one shown below should now appear, left click on the + button.
Lazarus and MS Access DB on Windows 7 64-bit7 of 10 Christopher W. Left click on the Start ( ) button on of Windows 7, navigate to All Programs, navigate to and left click once on Lazarus, left click on Lazarus. This now concludes the creation of the SQLite database sqlite1.db 2.3.4 Left click on the Save button, when complete, close the database. 2.3.3 Repeat the above steps to add more rows of data. WellsĢ.2.8 Left click on File, navigate and left click on Save Database As, locate the Lazarus_MSAccess folder and save the database file as MyAccess.Ģ.3 Add information to the database called MyAccess.accdb 2.3.1 Left click on the Student table, a similar screen shown below should now be displayed.Ģ.3.2 Simply fill in the required information for column as you require. Lazarus and MS Access DB on Windows 7 64-bit6 of 10 Christopher W. WellsĬolumn1 = Student_ID of type NUMBER Column2 = Fname of type TEXT Column3 = Sname of type TEXT Column4 = Subject of type TEXTĢ.2.5 Left click on the Close button to have the below prompt appear, left click on Yes to accept the changes:Ģ.2.6 The below prompt will now appear, rename the table to Student and then left click on OK to accept the changes:Ģ.2.7 Your screen should now look similar to the one shown below, left click on the Student table and you should see the results as shown above. Lazarus and MS Access DB on Windows 7 64-bit5 of 10 Christopher W. WellsĢ.2.3 A screen similar to the one shown below should now appear:Ģ.2.4 Rename the columns and activate the relevant database restrictions. Lazarus and MS Access DB on Windows 7 64-bit4 of 10 Christopher W.
Left click on the Start ( ) button on of Windows 7, navigate to All Programs, navigate to and left click once on Microsoft Office, left click on Microsoft Access 2010.Ģ.2.2 A screen similar to the one shown below should now appear, left click on the New button, left click on Blank database option and then left click on the WellsĢ.1.3 Left click on the New Folder option from the file menu, rename the “New Folder” to Lazarus_MSAccess and press the Enter key on your keyboard.Ģ.1.4 This ends the creation of the Lazarus_MSAccess folder.Ģ.2 Create the database MyAccess.accdb 2.2.1 Lazarus and MS Access DB on Windows 7 64-bit3 of 10 Christopher W. The name of our C: drive is called “Local Disk (C:)” as shown in the diagram. WellsĢ.1.2 Left click on the right arrow of Computer, and then left click on your C: drive N.B. Lazarus and MS Access DB on Windows 7 64-bit2 of 10 Christopher W. The above steps will all be highlighted in screen dumps for you below:Ģ.1 Create the folder Lazarus_MSAcess 2.1.1 Left click on the Start ( ) button on of Windows 7, navigate to All Programs, navigate to and left click once on Accessories, left click on Windows Explorer. 4.Ĭreate a folder on the C: drive called Lazarus_MSAccess Create a database called MyAccess.accdb Add information to the database called MyAccess.accdb Create the Lazarus / Delphi program
Ms access 2007 driver for windows 7 64 bit download software#
Lazarus 1.2.0 or newer - Ģ Database Example Program Below are the steps involved in using the installed software to create your first database application using both Lazarus and MS Access. Microsoft Access Database Engine 2010 Redistributable (32-bit) - 3. Microsoft Windows 7 (32-bit / 64-bit) – 2. Wellsġ Software requirements You will need to make sure you have the following software before continuing with the example program: 1. Lazarus and MS Access DB on Windows 7 64-bit1 of 10 Christopher W.
0 kommentar(er)
