-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
You are referring to "split database." This consists of 2 files: one
contains the data tables (the back-end), the other contains the
Queries, Forms, Reports, (Data Access Page in A2K & >), and Modules
(the front-end). The back-end file is "linked" to the front-end file.
See the Access Help topic "Import or link data and objects."
Also, on the Access menu bar click:
Access 97
To split the current database:
"Tools > Add-Ins > Database Splitter"
To maintain links to data tables:
"Tools > Add-Ins > Linked Table Manager"
Access 2000 & greater
To split the current database:
"Tools > Database Utilities > Database Splitter"
To maintain links to data tables:
"Tools > Database Utilities > Linked Table Manager"
MGFoster:::mgf
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBP6SPzYechKqOuFEgEQL+wQCdHybxxnuylBZ5te38lz5HbG 7KDnMAoJlz
LTbOeZL/FZLAC/c8QJr2/4zO
=U/EQ
-----END PGP SIGNATURE-----
intl04 wrote:
How do I create a data input form in Access that is external to the
Access database to which it's connected (if that's possible, which I
believe it is)? For example, if someone clicks on an Access file icon
on a computer desktop, it will open up a data entry form (that was
created in Access). That way, the people who enter the data won't have
direct access to the database at any point.
I've seen that this can be done, but I don't know how it's done. Does
it mean that the form and the database reside in two separate drives?
Do I need to go into 'view code' in the design view when creating
forms, to make any adjustments directly to the code?
Thanks in advance for any help on this.