access 2003 relationships oysterman 20.07.2006 14:27:02 Is there a way to establish a relationship between a table in one database with a table in another database? Tried query with <path>[field] but it was not recognized.

Re: access 2003 relationships "PaulD" <nospam> 20.07.2006 15:22:46 This may not be the 'right' way, but couldnt you make a linked table then make the relationship with the linked one? Paul D "oysterman" <oysterman[ at ]discussions.microsoft.com> wrote in message news:97E91368-41B8-4C51-B64B-C33E96FB46B7[ at ]microsoft.com... : Is there a way to establish a relationship between a table in one database : with a table in another database? Tried query with <path>[field] but it was : not recognized.

Re: access 2003 relationships oysterman 20.07.2006 15:56:02 I'll give it a try and let you know how it turns out. "PaulD" wrote: [Quoted Text] > This may not be the 'right' way, but couldnt you make a linked table then > make the relationship with the linked one? > Paul D > > "oysterman" <oysterman[ at ]discussions.microsoft.com> wrote in message > news:97E91368-41B8-4C51-B64B-C33E96FB46B7[ at ]microsoft.com... > : Is there a way to establish a relationship between a table in one database > : with a table in another database? Tried query with <path>[field] but it > was > : not recognized. > > >

Re: access 2003 relationships oysterman 20.07.2006 17:48:02 Paul, I tried the link function using the macro steps. I was asked for the complete path of the tables I wished to link. Unfortunately the database file type is an Access application not a directory of .dbf tables. The error message is that it cannot find the database without the database directory name and I can't see how to expand the database to show the various files/directories it contains. The helps don't provide a clue. "PaulD" wrote: [Quoted Text] > This may not be the 'right' way, but couldnt you make a linked table then > make the relationship with the linked one? > Paul D > > "oysterman" <oysterman[ at ]discussions.microsoft.com> wrote in message > news:97E91368-41B8-4C51-B64B-C33E96FB46B7[ at ]microsoft.com... > : Is there a way to establish a relationship between a table in one database > : with a table in another database? Tried query with <path>[field] but it > was > : not recognized. > > >

Re: access 2003 relationships "PaulD" <nospam> 20.07.2006 19:13:34 maybe I'm confused, it has been known to happen... If I'm in access looking at the list of tables, I select the new button at top, one of my options on the right is Link Table. If I select link it takes me to a Link dialog box asking for an .mdb file. I can select an .mdb then it gives me a dialog showing the available tables. I pick the table I want to link and now that table is in my current .mdb file, linked to the other file. If I change data in either one, both are updated. Once I have the linked table, I can then use it in queries, relations, etc from the current mdb Paul D "oysterman" <oysterman[ at ]discussions.microsoft.com> wrote in message news:AFC888B2-A89B-49D2-AD37-446A7251AC0E[ at ]microsoft.com... : Paul, : : I tried the link function using the macro steps. I was asked for the : complete path of the tables I wished to link. Unfortunately the database : file type is an Access application not a directory of .dbf tables. The error : message is that it cannot find the database without the database directory : name and I can't see how to expand the database to show the various : files/directories it contains. The helps don't provide a clue. : : : "PaulD" wrote: : : > This may not be the 'right' way, but couldnt you make a linked table then : > make the relationship with the linked one? : > Paul D : > : > "oysterman" <oysterman[ at ]discussions.microsoft.com> wrote in message : > news:97E91368-41B8-4C51-B64B-C33E96FB46B7[ at ]microsoft.com... : > : Is there a way to establish a relationship between a table in one database : > : with a table in another database? Tried query with <path>[field] but it : > was : > : not recognized. : > : > : >

Re: access 2003 relationships "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 20.07.2006 20:31:49 No, there isn't. Think about it for a moment. How could you guarantee that both databases will always be accessible at the same time? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "oysterman" <oysterman[ at ]discussions.microsoft.com> wrote in message news:97E91368-41B8-4C51-B64B-C33E96FB46B7[ at ]microsoft.com... [Quoted Text] > Is there a way to establish a relationship between a table in one database > with a table in another database? Tried query with <path>[field] but it > was > not recognized.