+ Post New Thread
Results 1 to 12 of 12
MIS Systems Thread, Reading FMS from Access in Technical; Hi Is it possible to access FMS tables from Access? Thank you...
  1. #1

    Join Date
    Apr 2007
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Reading FMS from Access

    Hi

    Is it possible to access FMS tables from Access?

    Thank you

  2. #2

    Join Date
    May 2006
    Posts
    159
    Thank Post
    5
    Thanked 10 Times in 5 Posts
    Rep Power
    18

    Re: Reading FMS from Access

    Possible? Most likely

    From the experience of FMS being a total temperamental POS that seems to be stuck in Windows 95 land, I would be extremely reluctant to go anywhere near its innards, personally.

  3. #3

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,316
    Thank Post
    35
    Thanked 351 Times in 237 Posts
    Rep Power
    78

    Re: Reading FMS from Access

    I don't understand klawd's comment but connecting directly to a finance database would go against every auditor's ruling in the country!

  4. #4

    Join Date
    Apr 2007
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Reading FMS from Access

    well I am not much of an FMS fan myself. I think its the worst accounting system ever. Any real company with 2-5m budget (as most schools have) would have trouble surving if they used that kind of software.

    But its reporting is limited to say the least, and the user defined reports are not the most easy to do. Exporting reports to Excel is at a sad state as the header lines go all over the place.

    Why I could definetely do with an access links is the supplier database. In the new year, we started a brand new FMS database due to funding and bank reasons. But we are missing the hundernds of suppliers. And there is no way of exporting or printing the old suppliers list details.

    If I can access FMS tables from Access then I can print the supplier details list.

  5. #5

    Join Date
    Apr 2007
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Reading FMS from Access

    Quote Originally Posted by PhilNeal
    I don't understand klawd's comment but connecting directly to a finance database would go against every auditor's ruling in the country!
    I am not looking for a read/write connection. Read is all I need. In regards to audit perspective I am not too sure you are correct. Accounting systems like oracle, or Sage allow data to be accessed through ODBC links in a read only way.

    As I am not an auditor though I can't say that for sure.

  6. #6

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,590
    Thank Post
    109
    Thanked 762 Times in 593 Posts
    Rep Power
    180

    Re: Reading FMS from Access

    I would have thought that you would need some kind of auditing to show that the data has been viewed (and by who).

    It would be useful to be able to produce pretty charts and the like though.

  7. #7

    Join Date
    May 2007
    Location
    Suffolk
    Posts
    145
    Thank Post
    2
    Thanked 19 Times in 17 Posts
    Rep Power
    18

    Re: Reading FMS from Access

    Many moons ago I was asked to "FOX fix" an old FMS (DOS) error where the user had edited the old D-Base files in Excel.

    Personally I wouldn't touch it with a tree trunk unless it was dummy data.

  8. #8

    Join Date
    Nov 2006
    Posts
    547
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Reading FMS from Access

    Whats FMS?

  9. #9

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,316
    Thank Post
    35
    Thanked 351 Times in 237 Posts
    Rep Power
    78

    Re: Reading FMS from Access

    It's the SIMS Financial Management System.

  10. #10

    Join Date
    Jan 2007
    Posts
    423
    Thank Post
    7
    Thanked 30 Times in 26 Posts
    Rep Power
    21

    Re: Reading FMS from Access

    We used to be an FMS school.. back in the day. However, we've now got the local authority's SAP setup and to be honest, both products seem to miss what's wanted.

    Does anybody here use Facility Accounts?

    Kyle

  11. #11
    limbo's Avatar
    Join Date
    Aug 2005
    Location
    Birmingham
    Posts
    460
    Thank Post
    2
    Thanked 41 Times in 36 Posts
    Rep Power
    25

    Re: Reading FMS from Access

    Before our move to CMIS we used to have SIMS and FMS - not sure how FMS has moved on since those days (guessing not a lot) but I used to take a copy of the database files and then access these copies with a read only connection for reports.

    Making the copy meant it was safe because I was not accessing it live (also helped prevent locked files etc.)

    Did this mainly with SIMS student data rather then FMS, but the principle I would have thought is the same.

    Alternatively an ODBC connection would probably be read only anyway so no danger or audit problems there.

    Just the question about who owns the database - the school or Capita - and therefore whether you are allowed to access it.

  12. #12
    limbo's Avatar
    Join Date
    Aug 2005
    Location
    Birmingham
    Posts
    460
    Thank Post
    2
    Thanked 41 Times in 36 Posts
    Rep Power
    25

    Re: Reading FMS from Access

    @Kyle - nearly forgot, we us a version of Facility accounts and it works, but our Bursar sometimes has problems with it.

    This year I think the February upgrade created problems setting up the new financial year and many school had to hang fire for another upgrade which was a bit close to the wire. Fortunately our Bursar had done it pre-upgrade so it was not a problem.

    It seems to get more stable with each release.

SHARE:
+ Post New Thread

Similar Threads

  1. SIMS training/reading [advice please]
    By contink in forum MIS Systems
    Replies: 7
    Last Post: 21st November 2007, 04:26 PM
  2. Reading an Access database with .Net 2.0
    By Jobos in forum Web Development
    Replies: 2
    Last Post: 22nd May 2007, 09:49 AM
  3. MS Access
    By wesleyw in forum How do you do....it?
    Replies: 1
    Last Post: 9th November 2006, 09:50 AM
  4. FTP Access
    By ben_hampshire in forum Windows
    Replies: 7
    Last Post: 27th April 2006, 11:44 AM
  5. Assistant Network Manager - Reading
    By tosca925 in forum Educational IT Jobs
    Replies: 0
    Last Post: 20th September 2005, 11:13 PM

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
  •