Results 1 to 5 of 5
  1. #1
    rosscortb is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jan 2011
    Posts
    52

    Issue viewing all records on a split database

    Hello,



    I have a split database with the back end on a sharedrive. I have the front end saved on my own drive and the same for my colleague.

    When I view the front end version of my colleagues, I can see a records on there that she has input but I can't see them when I open my own copy of the front end plus when I view the back end I can't see the records there at all. Anyone know why this is happening?

    Thanks

    Ross

  2. #2
    lfpm062010 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2013
    Location
    US
    Posts
    415
    Are you sure the table on the frontend is linked to the backend tables?
    I'm not sure it will help not it will not hurt. Try to compact and repair the backend and frontend database.
    Also try to re-link and double check the frontend table to make sure they are point to the correct backend database tables.

  3. #3
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    colleague is linked to a different back end....that is the only explanation.

  4. #4
    rosscortb is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jan 2011
    Posts
    52
    I sent her a fresh copy and linked it again and she now sees what i see, she created a record and I looked in the back end and it's there. So, I don't know where she linked the back end too, I can't find it......

  5. #5
    lfpm062010 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2013
    Location
    US
    Posts
    415
    The link manager should show you where the linked table is or if you hover the linked table it will also show you where the backend database database file is.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Deleted records by mistake from a split database
    By jasonoleary72 in forum Access
    Replies: 2
    Last Post: 03-28-2013, 02:12 PM
  2. Viewing database pictures
    By Mnelson in forum Access
    Replies: 1
    Last Post: 07-10-2012, 03:31 PM
  3. Replies: 3
    Last Post: 08-23-2011, 04:35 PM
  4. Replies: 1
    Last Post: 03-14-2011, 04:27 PM
  5. Picture loading and viewing issue
    By Kencao in forum Access
    Replies: 2
    Last Post: 02-23-2010, 12:43 PM

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