I also wanted it so I could make a new record by filling out the form, and hitting the new button.
I want it so it can delete the selected / presented record (namely basing it off the id field, such as 1 or 2). OLEDB.4.0;" db Source = "Data Source = C:\Documents and Settings\Eric\My Documents\Visual Studio 2010\Projects\EGI Movie Catalog\EGI Movie Catalog\db1.mdb" con.
") End Sub Private Sub btnreconnect_Click(By Val sender As System.
OLEDB.4.0;" db Source = "Data Source = C:\Documents and Settings\Eric\My Documents\Visual Studio 2010\Projects\EGI Movie Catalog\EGI Movie Catalog\db1.mdb" con.
In a nutshell, you are being asked for the primary key for the table.
If you are privy to this information please select the correct field because performance depends on it.
The first step in setting up a linked table is to navigate to the Linked Tables dialog in Access.
In some respects, it is the perfect tool for the casual business user who wants to drill into and share their data. In order to connect to Microsoft SQL Server from Microsoft Access you need to set up at least one Linked Table.
If you have rights to the database associated with the DSN you will be presented with a listing of database objects (note that you are not limited to linking just to tables, but rather views and stored procedures are available options also).
We are going to focus strictly on linking to SQL Server tables for this exercise.
This table is a pointer to a table in a SQL Server database that is associated with a pre-defined System ODBC Data Source Name (referred to as a DSN from this point forward).
In truth, you have many options for setting up Linked Tables from Access; many RDBMSs (Relational Database Management Systems) and Microsoft Office applications for example - even Share Point and Outlook are options for linking tables back to Microsoft Access.