I've developed a Delphi application which uses the Jet engine to access an MS Access
database. Currently the database is on the same machine as the application, but there would
be a benefit if I could keep the database on a file server. How does Access deal with this? Is
there a massive performance hit? My ideal solution would be to hold the database on a remote server and access it from clients. The network infrastructure is already in place to allow the network drives to be mapped. There is a half way house solution which would be to
copy the database to a fileserver in each of the remote locations as opposed to copying to the remote server..
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.
The problem with sub-reports and headings:
Add a dummy group to the sub report using the expression =1:
Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship.
Add the tables:
Create the relationship:
Decide if you’re going to set referential integrity:
Decide if you want cascade upda…