+ Post New Thread
Results 1 to 12 of 12
Windows Thread, MS Access files in Technical; Hey We have blocked all exes running from kids home drives and USB sticks but the local computer exes like ...
  1. #1
    timbo343's Avatar
    Join Date
    Dec 2005
    Location
    Leeds/York area, North Yorkshire
    Posts
    2,992
    Thank Post
    287
    Thanked 283 Times in 197 Posts
    Rep Power
    118

    MS Access files

    Hey

    We have blocked all exes running from kids home drives and USB sticks but the local computer exes like word and access still work ok. The problem we have got is that when a user tries to open a .mdb file from windows explorer, it says that there is a software restriction but if you open up access first then open the file, the database opens fine. In GPO i have made sure that under user config > windows settings > Security settings > software restriction policies > Designed file types i have removed the extensions MDB and MDE but it still throws up an error. Just for a bit more info, it works file when you open a .doc file.

    Can anyone suggest what else access uses to open the mdb files.

    T

  2. #2

    Join Date
    Jul 2005
    Location
    North Wales
    Posts
    54
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: MS Access files

    some versions create an LDB lock file in the same location as the database.
    If that doesn't work, grab filemon (or similar) and watch what's happening when you open the database on an unrestricted PC.

  3. #3

    Join Date
    Jul 2006
    Location
    London
    Posts
    2,962
    Thank Post
    159
    Thanked 152 Times in 116 Posts
    Rep Power
    49

    Re: MS Access files

    I am having the same problem - timbo did you manage to fix it?

    Ive removed anything to do with Access in designated file types and also used FileMon to watch activity and it doesnt open anything else except fonts

    Its just a really stupid problem and means all the hard work Ive done with this restriction policy might be wasted because teachers are moaning that kids cant open their databases (although you can open access and open from there)

  4. #4

    mac_shinobi's Avatar
    Join Date
    Aug 2005
    Posts
    9,729
    Thank Post
    3,252
    Thanked 1,049 Times in 971 Posts
    Rep Power
    364

    Re: MS Access files

    Just out of curiousty what did you do to stop students from executing exe files on there USB memory sticks ?

  5. #5
    tarquel's Avatar
    Join Date
    Jun 2005
    Location
    Powys, Mid-Wales, UK
    Posts
    1,740
    Thank Post
    13
    Thanked 44 Times in 34 Posts
    Rep Power
    29

    Re: MS Access files

    Best way is using Windows Server 2003 R2 gecko, using the File Server Resource Manager > File Screening Management

    Its so easy even *I* can do it

    Nath.

  6. #6

    Join Date
    Oct 2006
    Location
    Robert Mays School, Hampshire
    Posts
    100
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: MS Access files

    R2 is different to SP2 IIRC....


    Where can I get R2 from?

    Many thanks...

  7. #7

    mac_shinobi's Avatar
    Join Date
    Aug 2005
    Posts
    9,729
    Thank Post
    3,252
    Thanked 1,049 Times in 971 Posts
    Rep Power
    364

    Re: MS Access files

    you can only do that on so many places cant you with the file screening ?

  8. #8

    Join Date
    Jun 2006
    Location
    Belfast, N\'Ireland
    Posts
    190
    Thank Post
    10
    Thanked 9 Times in 7 Posts
    Rep Power
    18

    Re: MS Access files

    I have exactly the same issue myself.

    I quickly discovered they could open them from inside access and informed teachers and that is now what they do. Its untidy tho and I'd really like to know why every other office document type opens just fine except .mdb and .mde files.

  9. #9
    mrforgetful's Avatar
    Join Date
    May 2006
    Posts
    1,637
    Thank Post
    7
    Thanked 15 Times in 15 Posts
    Rep Power
    22

    Re: MS Access files

    We have a problem where some students cannot create reports. It goes through all the motions then gets an error. Sorry that's a bit vague, just remembered.

  10. #10

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,344
    Thank Post
    624
    Thanked 1,584 Times in 1,421 Posts
    Rep Power
    414

    Re: MS Access files

    Stese: R2 is a new product you have to buy a licence for it before you can install it.

    Ben

  11. #11

    Join Date
    Jun 2006
    Location
    Belfast, N\'Ireland
    Posts
    190
    Thank Post
    10
    Thanked 9 Times in 7 Posts
    Rep Power
    18

    Re: MS Access files

    We frequently have a problem with reports after a room is re-imaged. The wizrd will get to the last part and then fail or if you try to create in design view it will just fail to open with no error.

    I've found it to be printer related. I forget the exact process for this because its been september since we re-imaged anything but I find logging into one machine as admin opening an access database with an existing report created, going into page setup and making sure everything is correct then printing a copy and suddenly the whole room will be creating reports fine again.

    It bothers me that I'm not sure exactly why this works but it has done countless times now.

    Now if they could just open access databases from explorer I'd be happy

  12. #12
    mrforgetful's Avatar
    Join Date
    May 2006
    Posts
    1,637
    Thank Post
    7
    Thanked 15 Times in 15 Posts
    Rep Power
    22

    Re: MS Access files

    Cheers Teth I'll give it a go tomorrow

SHARE:
+ Post New Thread

Similar Threads

  1. Access files from home
    By Jobos in forum Windows
    Replies: 23
    Last Post: 25th November 2010, 10:04 AM
  2. MSI Files.
    By boomam in forum How do you do....it?
    Replies: 14
    Last Post: 9th November 2007, 12:50 PM
  3. .nrg files HELP!
    By thegrassisgreener in forum Windows
    Replies: 5
    Last Post: 6th September 2007, 06:57 PM
  4. WDS and .WIM files.
    By starscream in forum Wireless Networks
    Replies: 1
    Last Post: 4th July 2007, 02:37 PM
  5. Offline Files
    By woody in forum Windows
    Replies: 2
    Last Post: 9th December 2005, 10:52 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •