By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,948 Members | 1,929 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,948 IT Pros & Developers. It's quick & easy.

how to create an Access data input form external to db?

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Create a second database to your main database. Create one or more tables in
your second database to contain the data you want to use in the main database.
Create one or more forms in the second database to input the data into the
second database. In the main database create linked tables to the tables in the
second database. You can now give users access to the second database for data
entry. They will not be able to access the main database. However, you will be
able to use the data that was entered from the main database.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
www.pcdatasheet.com
"intl04" <in****@hotmail.com> wrote in message
news:b7**************************@posting.google.c om...
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.

Nov 12 '05 #2

P: n/a
-----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.


Nov 12 '05 #3

P: n/a
That worked great - thanks so much! Just another question: Is there
any way to create and run reports in that second db that are based on
queries in the main db? (The queries are built from 3-4 tables linked
together, but I want only one table - the table in the second,
data-entry db - to be modifiable.)

It seems that if I replicate all the queries in the second db, all the
other tables (from the main db) have to be there as well, to generate
those queries. Of course, in that case, there's the risk that multiple
tables' data will be accidentally modified by data inputters.

I tried a database split that was recommended by another respondent,
but all the tables in the front-end db were linked to the back-end db
and were modifiable. Of course, when I deleted the other linked tables
from the front-end db (the ones that I did not want to be modifiable,
I could not run any queries that generate data from the tables linked
together.


"PC Datasheet" <sp**@nospam.com> wrote in message news:<Cp****************@newsread2.news.atl.earthl ink.net>...
Create a second database to your main database. Create one or more tables in
your second database to contain the data you want to use in the main database.
Create one or more forms in the second database to input the data into the
second database. In the main database create linked tables to the tables in the
second database. You can now give users access to the second database for data
entry. They will not be able to access the main database. However, you will be
able to use the data that was entered from the main database.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
www.pcdatasheet.com
"intl04" <in****@hotmail.com> wrote in message
news:b7**************************@posting.google.c om...
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.

Nov 12 '05 #4

P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You can run a report in one front-end using a query in another .mdb/e
file by using a RecordSource property like this:

SELECT * FROM qryOtherQueryName In "C:\My Doc\OtherDB.mdb"

See the Access Help topic on the In predicate.

- --
MGFoster:::mgf
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP6X79YechKqOuFEgEQIkAwCg2L3yBxd18LeNP0rw/k1arL3cvhAAoPC+
Ht36pw6nUAfhxZkuQYDrIQ2J
=5CRN
-----END PGP SIGNATURE-----
intl04 wrote:
That worked great - thanks so much! Just another question: Is there
any way to create and run reports in that second db that are based on
queries in the main db? (The queries are built from 3-4 tables linked
together, but I want only one table - the table in the second,
data-entry db - to be modifiable.)

It seems that if I replicate all the queries in the second db, all the
other tables (from the main db) have to be there as well, to generate
those queries. Of course, in that case, there's the risk that multiple
tables' data will be accidentally modified by data inputters.

I tried a database split that was recommended by another respondent,
but all the tables in the front-end db were linked to the back-end db
and were modifiable. Of course, when I deleted the other linked tables
from the front-end db (the ones that I did not want to be modifiable,
I could not run any queries that generate data from the tables linked
together.


"PC Datasheet" <sp**@nospam.com> wrote in message news:<Cp****************@newsread2.news.atl.earthl ink.net>...
Create a second database to your main database. Create one or more tables in
your second database to contain the data you want to use in the main database.
Create one or more forms in the second database to input the data into the
second database. In the main database create linked tables to the tables in the
second database. You can now give users access to the second database for data
entry. They will not be able to access the main database. However, you will be
able to use the data that was entered from the main database.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
www.pcdatasheet.com
"intl04" <in****@hotmail.com> wrote in message
news:b7**************************@posting.google .com...
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.


Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.