Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

can't consolidate companies to use in Access

can't consolidate companies to use in Access

can't consolidate companies to use in Access

I am using MAS200 Client Server Edition 4.3.

I have three divisions for the same company set up as three separate companies in MAS200.  This was the desire of the company who did not want equal access by all staff working on separate companies to one consolidated AP and AR.  Previously, this was not a problem, but they are beginning to request reports which require the data be consolidated before selection criteria applied in Crystal Reports.   Since I cannot do this in Crystal, I am turning to Access which I understand will do this for me.  

My question is, I know how to use Access and merge data once it is populated, but I don't know how to set up all three companies to dynamically update my tables to one Database.  Thanks in advance!


RE: can't consolidate companies to use in Access

IMHO setting up the divisions that way was an extremely poor decision.  Mgmt's insecurity about the security is needlessly adding additional overhead expense.

You can consolidate MAS 90 data in Access by setting up muliple Linked ODBC MAS 90 tables.  The table names will have to use different names than the original table.  If you create several pass through queries, the response time will be faster.  The other option would be to setup multiple silent MAS 90 ODBC connections.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close