Linked Table

[Juan4412]

I have a database where the table is linked to about 3 other databases. If I add fields to my "Main" table, will it cause errors in the reports and "communication" between the other databaes that the table is linked?

[TheShabz]

It shouldn't as it's merely a link to, not an import of, your table. However, it is courtesy for a table owner to send out an email to users telling them to refresh the link to the table once any change has been made to the table definition.

[Juan4412]

How would the users refresh the link to there table?

[TheShabz]

This link might help

[Juan4412]

Oh, haha. I did not know it was that easy! But simply adding new fields to the table should not "harm" any relations, correct?

[TheShabz]

It should not. But who knows. It's Microsoft. Anything is possible.

[Juan4412]

Hey btw that video you made on google was really neat. How did you make that? And thanks for the help!

[TheShabz]

I didn't make the video. go to www.lmgtfy.com (Let Me Google That For You) and you can make them yourself.

[Juan4412]

i updated the links to my tables, but i think i did it wrong now i have tthe tables linked and in both databases. but its in my main db twice as table and table1? how do i fix tthis?

[TheShabz]

are the total duplicates? data/dimensions/everything? If so, backup the db then delete everything with a 1

[Juan4412]

Yes they are total duplicates. I checked the data and both tables match up correctly. Since the tables are linked, should I remove them from my FE database, so that when I update the tables again this same thing does not ocur?

[TheShabz]

OH its a split DB. When working with a split DB, you simply make another FE and distribute them to your users. They don't have to refresh anything. I was under the impression they were sinking to your tables from their own Dbs.

[Juan4412]

Sorry I should have been more specific. Yes it is a split database. I was unsure what exactly I was doing, and now my FE and my BE database have the tables! But they are talking to one another. I want to remove the table from my FE and keep it only on my BE, but still have my form, pull the data from my BE database. How do I go about removing the tables from the FE without messing up things?

[TheShabz]

Split your BE again to make a new FE. Replace everyone's FE with the new one. Here's more info.

http://www.fmsinc.com/microsoftacces...ter/index.html

[Juan4412]

There is a form with my FE database that is only with the FE if i resplit etc I will loose it. Is there a way to just select which tables I want to link/split?