Re: Using data from Linked Tables

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi John,

Yes, I am assuming that linked tables are not editable. How do you make them
editable? Can you add new fields to a linked table?

As I said in my previous post, our company software is Vantage, and I have
exported a query from there and linked it in Access. The linked table has
the order and number of service days sold. Beyond that I need to keep track
of the dates of serivce provided. What would be the best way to do this?

Thank again. I look forward to hearing your reply.

Mary



"John W. Vinson" wrote:

On Mon, 30 Apr 2007 13:00:01 -0700, Mary <Mary@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

I have a linked table. Is there a way to link that table with a table that
can be updated?

In other words: i want to use all the data in tblLinked (cannot be updated)
in tblNewInformation (can be updated).


What do you mean by "use"?

You can *copy* the data into a (redundant) second local table, where it can
then be edited. Of course these edits will not be reflected in the original
linked table.

If you want to be able to update the linked table, then you need permissions
to update it. Or are you assuming (incorrectly) that linked tables are ipso
facto not editable?

John W. Vinson [MVP]

.

Relevant Pages

  • Creating many forms from one table - Newbie - John W. Vinson
    ... John W. Vinson wrote: ... Creating many forms from one table - Newbie ... A good spreadsheet design is often a very bad table design. ...
    (microsoft.public.access.forms)
  • Re: Q: changing Table in form
    ... "John W. Vinson" wrote: ... because it opens up another window. ... that they pull from a system, create an Excel spreadsheet and email to ...
    (microsoft.public.access.modulesdaovba)
  • Re: Form tutorials?
    ... "John W. Vinson" wrote: ... know if anyone can point me to relevant tutorials. ... A free tutorial written by Crystal (MS Access MVP): ...
    (microsoft.public.access.forms)
  • Re: seeking a field
    ... "John W. Vinson" wrote: ... In design view of... ... headings that match the text content of the field. ...
    (microsoft.public.access.gettingstarted)
  • Re: Load multiple records per form
    ... "John W. Vinson" wrote: ... Only by the state code, ... you're using a relational database, and you can use it relationally. ...
    (microsoft.public.access.forms)