Hide linked table

[mls via AccessMonster.com]

Hi all,

I want to link a column of my form to a column\table in another database xx.
mdb. This column should update and refresh with all the new data. at the same
time I wan to hide this so that no one accidentily deletes this table. Also
can I enforce referential integrity in my database as I have read-only with
xx.mdb?

Thanks

 

[Stefan Hoffmann]

hi,

I want to link a column of my form to a column\table in another database xx.
mdb. This column should update and refresh with all the new data. at the same
time I wan to hide this so that no one accidentily deletes this table.

This makes no sense to me. Simply create a *.mde file and disable the
shift key:

http://support.microsoft.com/kb/826765

And also disable the database window and Access special keys in the
Extras/Startup menu.

Also can I enforce referential integrity in my database as I have read-only with
xx.mdb?

You cannot ensure RI over different *.mdb files.


mfG
--> stefan <--

 

[Linq Adams via AccessMonster.com]

As Stefan said there's little sense in your post as it currently reads. You
say:

"I want to link a column of my form to a column\table in another database
xx.mdb. This column should update and refresh with all the new data."

And then you say:

"I have read-only with xx.mdb"

How are you going to update the data in this column if you have Read-Only
rights to xx.,db?

 

[mls via AccessMonster.com]

I am sorry for not being clear.

In my form I have lab id as list box control and want to populate it with
distinct lab id from the different database xx.mdb, whcich is read only for
our team.
My question is how can I update my form drop down with the most current list
of lab id from different database.
To do this instead of importing the table every time I am planning to create
a link in my database to that xx.mdb table, at the same time want to hide
this linked table.

Hope this is clear.

Thanks

 

[Stefan Hoffmann]

hi,

My question is how can I update my form drop down with the most current list
of lab id from different database.
To do this instead of importing the table every time I am planning to create
a link in my database to that xx.mdb table, at the same time want to hide
this linked table.

Yup. Create a linked table and use this linked table as source for your
combo box.

There is need to hide this linked table as it can be easily revealed.


mfG
--> stefan <--

 

[mls via AccessMonster.com]

My question is how can I hide the link table?

hi,

Yup. Create a linked table and use this linked table as source for your
combo box.

There is need to hide this linked table as it can be easily revealed.

mfG
--> stefan <--

 

[mls via AccessMonster.com]

never mind, I got this done. Right click on the table --> properties --->
hide.

Thanks

My question is how can I hide the link table?

hi,

[quoted text clipped - 10 lines]

mfG
--> stefan <--

 

[Dirk Goldgar]

hi,

Yup. Create a linked table and use this linked table as source for your
combo box.

For that matter, one could set the list box's rowsource to a SQL statement
that directly queries the table in the foreign database, without any linked
table at all. For example:

SELECT * FROM
[MS Access;database=C:\Some Path\ForeignDB.mdb].ForeignTable;

 

[mls via AccessMonster.com]

Actually I need 3 columns from the foreign database so how can I get these
set up for my 3 contorls in the form.
Say I need to link patientid, source and nationality from foregin database.
table . If some one do a find on 5 th patient his nationality and source
should come up.
Do I need to create a seperate staging table and point the controls to these
fields?

hi,

[quoted text clipped - 7 lines]

Yup. Create a linked table and use this linked table as source for your
combo box.

For that matter, one could set the list box's rowsource to a SQL statement
that directly queries the table in the foreign database, without any linked
table at all. For example:

SELECT * FROM
[MS Access;database=C:\Some Path\ForeignDB.mdb].ForeignTable;

 

[Dirk Goldgar]

Actually I need 3 columns from the foreign database so how can I get these
set up for my 3 contorls in the form.
Say I need to link patientid, source and nationality from foregin
database.
table . If some one do a find on 5 th patient his nationality and source
should come up.
Do I need to create a seperate staging table and point the controls to
these
fields?

I'm sorry, I don't understand exactly what you're wanting to do. What are
the relevant tables and fields in the "foreign" database? If there are more
than one table, how are they related?

You previously spoke only of a single control on your form -- a list box or
a combo box. Now you say "3 columns" and "3 controls". You *could* have a
list or combo box show multiple columns drawn from the foreign rowsource,
but it isn't clear to me if that will be adequate to your needs, since that
information wouldn't be available for other forms or reports in your
database. If you need that, you would probably do better with a linked
table, whether hidden or not.

 

[mls via AccessMonster.com]

In reality, I am planning to read from 2 tables of foreign database.

labid, nationality, specimen from tableA,
date_received, sender from tableB

When lab tech open the form to input test results. I want the [foreign.mdb]
tableA.labid, [foreign.mdb]tableA.nationality, [foreign.mdb].tableA.specimen,
[foreign.mdb].tableB.date_receied,[foreign.mdb].tableB.sender to be filled in
already so that lab tech can just enter the test results. And when they click
save all the values from the form should be saved into our database table.

Is this possible with out coding?

Thanks a lot

Actually I need 3 columns from the foreign database so how can I get these
set up for my 3 contorls in the form.

[quoted text clipped - 5 lines]

these
fields?

I'm sorry, I don't understand exactly what you're wanting to do. What are
the relevant tables and fields in the "foreign" database? If there are more
than one table, how are they related?

You previously spoke only of a single control on your form -- a list box or
a combo box. Now you say "3 columns" and "3 controls". You *could* have a
list or combo box show multiple columns drawn from the foreign rowsource,
but it isn't clear to me if that will be adequate to your needs, since that
information wouldn't be available for other forms or reports in your
database. If you need that, you would probably do better with a linked
table, whether hidden or not.

 

[Dirk Goldgar]

In reality, I am planning to read from 2 tables of foreign database.

labid, nationality, specimen from tableA,
date_received, sender from tableB

When lab tech open the form to input test results. I want the
[foreign.mdb]
tableA.labid, [foreign.mdb]tableA.nationality,
[foreign.mdb].tableA.specimen,
[foreign.mdb].tableB.date_receied,[foreign.mdb].tableB.sender to be filled
in
already so that lab tech can just enter the test results. And when they
click
save all the values from the form should be saved into our database table.

Is this possible with out coding?

I'm not sure yet. How are these foreign tables related to each other, and
to the table on which your form is based? I don't see any connection, so I
don't see how the form can automatically select any particular records from
these tables.

Now, if what you mean is that you want list or combo boxes to have their
lists drawn from these tables, so that the user can select values from them,
then that can be done easily enough, but not without a little coding. If
you want to select a particular row from tableA, and have the labid,
nationality, and specimen values from that row be saved into three separate
fields in your form's recordsource table, that can be done, but be warned
that you may be storing unnormalized data.