Access 2007 Linked table manager
Posted on 2008-10-14
I apologize as i know nothing about access whatsoever, just that i should be able to get into the linked table manager (not that i know how it works) . I have been given a database that was made in access 2003, in which the linked table manager was accessible, but in 2007 it is greyed out. When i go into Relationships, there doesn't appear to be any links. If i add some links and then select the applicable tables, it stays greyed out.
I tried making a new database, adding two tables with some random fields, and adding a link between them. It's still always greyed out.
I also read something about it only being available in the backend database. Again i have no idea what this means, but i found how to split the database to create a backend one, but still in that one it was greyed out (both with the big database and the new little one).
What exactly is needed to make it accessible?
Thanks a lot in advance for your help,