Can this be done? Link tables between 2 different databases

[KEKeogh]

Before I try to research this too much I thought I'd as our wonderful group here if this can even be done in Access 2000.

I have one database I use to keep track of all my school runs, kids, and drivers.

Another co-worker has a database that has all the vehicle information.

What I'm wondering is since my table that lists run names changes frequently and she's wanting to assign vehicles to these runs...

Can we link a field in her database to pull the run information from my database? So that whenever I update a run name in my database it's reflected in hers.

Hopefully I explained that well enough.

Thanks
Kathie

FYI: I'm just really learned the ins and outs of Access as I go along.

 

[Mr. B]

Yes, you can create a link to one or more tables in her database or she can have links to tables in your database. You can then use the data from a linked just the same way you would use the data if the table was actually located in the database you have open.

 

[KEKeogh]

Thanks!

I looked a little further at the menus and managed to find exactly what I needed.

This forum sure is a life saver!

Kathie