Page 1 of 2 12 LastLast
Results 1 to 15 of 20
  1. #1
    Juan4412 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Dec 2010
    Posts
    209

    Linked Table

    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?

  2. #2
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    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.

  3. #3
    Juan4412 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Dec 2010
    Posts
    209
    How would the users refresh the link to there table?

  4. #4
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368

  5. #5
    Juan4412 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Dec 2010
    Posts
    209
    Oh, haha. I did not know it was that easy! But simply adding new fields to the table should not "harm" any relations, correct?

  6. #6
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    It should not. But who knows. It's Microsoft. Anything is possible.

  7. #7
    Juan4412 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Dec 2010
    Posts
    209
    Hey btw that video you made on google was really neat. How did you make that? And thanks for the help!

  8. #8
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    I didn't make the video. go to www.lmgtfy.com (Let Me Google That For You) and you can make them yourself.

  9. #9
    Juan4412 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Dec 2010
    Posts
    209
    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?

  10. #10
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    are the total duplicates? data/dimensions/everything? If so, backup the db then delete everything with a 1

  11. #11
    Juan4412 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Dec 2010
    Posts
    209
    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?

  12. #12
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    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.

  13. #13
    Juan4412 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Dec 2010
    Posts
    209
    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?

  14. #14
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    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

  15. #15
    Juan4412 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Dec 2010
    Posts
    209
    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?

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 11-30-2010, 12:23 PM
  2. Linked Table!
    By watzmann in forum Access
    Replies: 1
    Last Post: 10-11-2010, 06:17 AM
  3. Replies: 1
    Last Post: 07-21-2010, 07:27 AM
  4. Replies: 3
    Last Post: 01-21-2010, 08:10 PM
  5. Replies: 2
    Last Post: 10-27-2009, 07:09 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums