MS Access & MAS 200

[Bobford]

How do I tie Access into the MAS Database?

I keep getting an error.

Thanks in advance.

Bob

 

[BigLouie]

Need a lot more information.

1. How are you attempting to tie Access to MAS.

2. What error message are you getting.

3. What are you trying to do.

 

[Bobford]

Hey Louie...

I was just going to try and use Access as a reporting tool.

I do not know the first step to tie it into the MAS Databases.

I tried a couple of things with no real results.

No real problem Louie just trying some different things.

Thanks

Bob

 

[BigLouie]

Normally you would write SQL Specific Pass Through Queries to link into the MAS datasource. Then write some other queries, either make table or append queries to populate tables. Then you create a form with code that allows you to dump the old data and populate with new data and then build your report off the tables. Very common. Lots of people do this.

Please be advised that it is best to keep the tables in another database and link them into the database with the code and form. This is because if you do a lot of refreshing of the data the database will grow in size until it hits 2 GB and at that point will stop working. Linking in the tables to be refreshed you do not have this.

 

[Blorf]

Quick question.

I am using Mas 200 V 3.71 and use access for report writing quite a bit.

Using Passthrough querries works, even eliminates need for log in info each and every time.

I do not however notice an increase in read performance using passthrough instead of just a linked table.

Is this normal?

Thanks,
ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

 

[BigLouie]

I like to use the pass throughs over linked because in the long run you will have less problems.

 

[Blorf]

Cool.

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.