Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jul 2003
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Linking Form to Other File (2000)

    I want the entries into a form in one Access file to appear in a table in another Access file. I don't want to import the table into the same file as the form. Any way to do this? Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Linking Form to Other File (2000)

    You can't link forms directly to another database, but you can create a link to a table in another database. If you base the form on the linked table, all data entered or edited in the form will actually be stored in the table in the other database.

    You must create the table in the other database first. Then, in the database with the form, select File | Get External Data | Link Tables...
    In the dialog that appears, browse to the other database, select it and click Link.
    Select the table, then click OK.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •