Results 1 to 4 of 4
  1. #1
    Outlook is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jan 2011
    Posts
    4

    Shortcut to front end for terminal server users

    Hi,

    I desperately need some help as I am tearing my hair out!

    I have a split and shared database for my company, but not all users can use the system. Why?

    Access 2010
    Split database
    Front & back ends saved on shared drive
    Shortcut on terminal server - Maybe shortcut is wrong?
    Shared database, not exclusive

    I have read somewhere that each user should have the front end saved to their computer, but I'm not sure this applies as the front end is currently on a shared drive. Also, surely space and memory wise, this isn't helpful? What happens when you want to update the front end - does everyone have to resave the new copy?

    Some users can use the system no problem, but other get an error code of: "Invalid database object reference".



    Please help me as I'm really not sure what to do for the best.

    Thanks.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Basically what you said is correct even when using TS service except the FE's are in different folders on the server. There are several free systems that can automaticall update the various FE's every time they are used.

  3. #3
    Outlook is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jan 2011
    Posts
    4
    Thank you.

    Can you suggest any? I wouldn't know where to start.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    http://www.btabdevelopment.com/ts/freetools
    I think Tony now charges but it is very robust and polished.
    http://autofeupdater.com/

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

Similar Threads

  1. Shortcut & .mdw
    By tbassngal in forum Security
    Replies: 3
    Last Post: 12-06-2010, 02:38 PM
  2. Date function in Terminal Server
    By eww in forum Access
    Replies: 8
    Last Post: 11-16-2010, 04:24 PM
  3. Front End vs. Shortcut
    By eww in forum Access
    Replies: 3
    Last Post: 11-12-2010, 03:02 PM
  4. Public Terminal Emulation
    By pkstormy in forum Code Repository
    Replies: 0
    Last Post: 08-31-2010, 02:09 AM
  5. Using Access 2007 runtime in Terminal Services?
    By Simon Sweet in forum Access
    Replies: 0
    Last Post: 03-15-2008, 11:46 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