+ Post New Thread
Results 1 to 11 of 11
Office Software Thread, Access - TEAM.mdb in Technical; Evening all, I've just started at a new school so I'm trying to pick up old problems that I know ...
  1. #1

    sonofsanta's Avatar
    Join Date
    Dec 2009
    Location
    Lincolnshire, UK
    Posts
    4,829
    Thank Post
    840
    Thanked 1,399 Times in 962 Posts
    Blog Entries
    47
    Rep Power
    603

    Access - TEAM.mdb

    Evening all,

    I've just started at a new school so I'm trying to pick up old problems that I know nothing about, which is proving... well, exhausting.

    It seems the school used to run an Access database called TEAM released by Education Software Ltd. in Warwick. It's fairly amateurish stuff of the sort often peddled to schools and thankfully we don't use it anymore (although we have Serco instead now...) but a teacher wants access to it for historical data.

    When I open the file (Team_2612.mdb) it complains about macros and security, but clicking through all that, as soon as I try and do anything in the database it crops up with "ODBC--connection to 'TEAM' failed". Oddly enough an older version of this file with outdated data has no such issues, so the Office installation would seem to be fine, and it's something specifically within this file.

    As far as I can guess, then, it's something to do with linked tables and such like. Is there anywhere I can find out what tables are linked, where it's trying to use the ODBC to get to etc? I don't suppose that anyone has actually had dealings with this software and can at least sympathise with me?

    I'll fire off an e-mail to the company who made it now but to be honest, I have more faith in edugeek getting me an answer than the company who made it.

    Thanks in advance... I may disappear soon as my eyes hurt from staring at Access now. Can't remember the last time I saw it used outside of a GCSE lesson, bleurgh indeed!

  2. #2
    TheLibrarian
    Guest
    I am not going to offer any comment one way or the other about TEAM.

    It could well be that your ODBC connection for that version of TEAM is no longer valid.

    Check the ODBC that the older version uses.

    Here's our current ODBC settings ripped from my registry:
    Code:
    Windows Registry Editor Version 5.00
    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Team]
    "Server"="sqldbsvr\\team"
    "Database"="Team"
    "Description"="Team 64bit SQL Database"
    "Trusted_Connection"="Yes"
    "Driver"="c:\\windows\\system32\\sqlsrv32.dll"
    "(Default)"="Team"
    I don't know if this will help in anyway, good luck.

  3. Thanks to TheLibrarian from:

    sonofsanta (9th December 2009)

  4. #3

    sonofsanta's Avatar
    Join Date
    Dec 2009
    Location
    Lincolnshire, UK
    Posts
    4,829
    Thank Post
    840
    Thanked 1,399 Times in 962 Posts
    Blog Entries
    47
    Rep Power
    603
    That might be the problem... there are no entries for TEAM on either my local machine or on the file server that the .mdb resides on.

    No idea how to fix that, but at least I know what I'm fixing now, thanks!

  5. #4
    TheLibrarian
    Guest
    Unfortunately I know little and nothing about TEAM, we (the royal we) use it here, but (thankfully) I don't personally have any need to use it or support it.

    We do have a T: drive mapped to a location on our MIS server, then I believe the TEAM Access database is copied to a local directory and run from there.
    After that, as I understand it, the Access database uses ODBC to connect to the SQL server.

    That is pretty much the sum total of my TEAM knowledge.

    Best of luck sorting it.

  6. #5
    robk's Avatar
    Join Date
    Nov 2005
    Location
    Ashbourne
    Posts
    672
    Thank Post
    170
    Thanked 126 Times in 105 Posts
    Blog Entries
    1
    Rep Power
    47
    I think there used to be two access dbs, one with the front end the other with the data in it.

    Have you migrated from SIMS by any chance? If so you may find a team db on the sims SQL server.

    Thats the route we took, though we left the team system just before the sql stage.

  7. Thanks to robk from:

    sonofsanta (9th December 2009)

  8. #6

    sonofsanta's Avatar
    Join Date
    Dec 2009
    Location
    Lincolnshire, UK
    Posts
    4,829
    Thank Post
    840
    Thanked 1,399 Times in 962 Posts
    Blog Entries
    47
    Rep Power
    603
    TEAM resides on the mapped T: drive here as well, coincedentally, although it's just a file server rather than the MIS server.

    And yes, we did migrate from SIMS around January afaik, and Serco now uses the SIMS2005 MSSQL server instance, so there may be a clash there, something else to investigate.

    As for databases - well, there's Team_2162 that is the Team database itself, and also a TEAM_Management3.1.mdb in the same folder. There's then a folder called KGGSdata with some MDBs in it but they seem to be aroudn a couple of years old and are probably useless in terms of data accuracy anyway.

    Even more entertainingly the e-mail I sent to the address listed in the User Guide just bounced

    Thanks for all your help guys, I really do appreciate it, it can be very frustrating getting a handle on these problems sometimes.

  9. #7

    sonofsanta's Avatar
    Join Date
    Dec 2009
    Location
    Lincolnshire, UK
    Posts
    4,829
    Thank Post
    840
    Thanked 1,399 Times in 962 Posts
    Blog Entries
    47
    Rep Power
    603
    Update ahoy!

    The same version of TEAM does indeed reside on our MIS server, which does indeed have the ODBC details in the registry for TEAM itself. If I run the Access file on the MIS server it works - if I copy that file over to the file server and run it, it fails. I may well just see if the file can be run from the MIS server instead of the file server, as only the ICT teacher needs access, so if he gets access we could be away...

    Thanks again, you've led me right to the door of the answer!

  10. #8

    sonofsanta's Avatar
    Join Date
    Dec 2009
    Location
    Lincolnshire, UK
    Posts
    4,829
    Thank Post
    840
    Thanked 1,399 Times in 962 Posts
    Blog Entries
    47
    Rep Power
    603

    Talking

    Result!

    The registry settings were the problem all along, thanks Librarian - having looked at the MIS server (thanks robk) and spotted the TEAM ODBC settings in there, all I had to actually do was export the registry settings, import them into a test computer, modify them slightly to C:\WINDOWS from C:\WINNT and the database file held on the file server ( T: ) now works as it should.

    Fantabulous. Thanks!
    Last edited by sonofsanta; 9th December 2009 at 01:38 PM. Reason: Stupid smilies!

  11. #9
    TheLibrarian
    Guest
    Heh, congrat's!

  12. #10
    robk's Avatar
    Join Date
    Nov 2005
    Location
    Ashbourne
    Posts
    672
    Thank Post
    170
    Thanked 126 Times in 105 Posts
    Blog Entries
    1
    Rep Power
    47
    Nice to hear its now working. Might have to do the same thing here shortly....

  13. #11
    MACIT's Avatar
    Join Date
    Sep 2008
    Posts
    51
    Thank Post
    1
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Hmmm we used to use team here, It was the first thing i kicked out based on the fact its like a GCSE project as opposed to a professional MIS system that is built for purpose. It does come close to the functionality of SAM especially in terms of data integrity.

    I have spent the last 12 months moving over to sims assessment manager and whilst i could pick flies with that system generally is extremely robust and i would recommend it to anyone.

    The migration from Team has been a long road so far but gradually im seeing the light at the end of the tunnel. The approach i took was to export all data from team and import into SAM so that we have historical lookup. I have maintained the Team SQL database for now but i will be removing it soon (will keep a backup just in case)

    just my perspective.

SHARE:
+ Post New Thread

Similar Threads

  1. Team Fortress 2
    By m1ddy in forum Gaming
    Replies: 0
    Last Post: 27th May 2009, 10:12 AM
  2. Team Review
    By Matt_Tate in forum General Chat
    Replies: 24
    Last Post: 23rd October 2008, 09:25 PM
  3. IT Team sizes?
    By plock in forum Network and Classroom Management
    Replies: 58
    Last Post: 2nd January 2008, 12:18 PM
  4. Exchange and outlook have blocked mdb files
    By timbo343 in forum Windows
    Replies: 11
    Last Post: 8th December 2006, 08:34 AM

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Posting Permissions

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