Personalization, Customization and Productivity Tools

[hockhollyred]

Does anyone have experience with running access and MAS 90. Have a client who has been running a access report on Job Cost for 10 years, updated to 4.3 and the report no longer works. I went into administrative tools and removed the old ODBC connection and readded it once the new driver was recognized but I still get an error message when I try to run the report that states "ODBC--connection to 'ACCESS MAS 90 ODBC' failed."

Any help would be appreciated. Thanks.

[DFeller]

You will probably need to change the connection string in the Access database itself.

Dawn

[connex]

It would depend on how the table is defined in MS Access.  If it is a pass through query then Dawn is correct and you merely need change the connection string in the properties of the table in design mode.

If it is a simple link, then delete it and re-link it. 

The difference between these types of definitions is that a link will show with the table objects with an arrow pointing to a globe.  The pass through query will show with the query objects as a globe with no arrow.

If neither of these appear to be how your table is defined then there may be some VBA code involved that is dependant on the prior version ODBC DSN.

[BigLouie]

In some instances linking tables in Access will not work with the newer versions of MAS. You have to use SQL Specific Pass Through Queries.

[hockhollyred]

Dawn:

What do you mean change the string in the database itself? Not an Access expert. I was making these changes in admin, data sources. Could you point me to a place I could get instructions on how to do it?

Thanks Holly

[DFeller]

Once you link a table in Access, it stores that connection information in the Access database.  If the path changes, you will want to drop and relink the tables, or setup pass-through queries.

Dawn

[BigLouie]

Holly it is better to use SQL Specific Pass Through Queries in Access as it returns data faster and with fewer erro messages compared to linking tables.  How to write a pass through has been posted a number of times. If you cannot find it let me know and I'll repost.

[zalmi]

BL

I have done quite complex reorts with Crystal and Access. Never had a problem. But I also never used pass-through. All of a sudden Crystal won't access the Access database. The Access itself won't work unless I close it and reopen it and it works fine till I try to run the Crystal. Then everything dies. (Why is that?) I have queries on queries so I guess I need to redo all the queries to Pass-through and try it that way. Can you please repost the pass through instructions for me so I have it down clearly? Thanks so much.

Z

[connex]

I doubt that your query type is the issue, although you can increase the speed of your queries with PTQ's if you set them up to transfer substantially fewer than all fields.

Did you update your MS Office? I have had issues with the MS Access driver that supports the newer .accdb file types. Check the drive name in the ODBC administrator for the supported file types.  The old drive can coexist with the newer one so that you can continue to use the old .mdb versions.

[zalmi]

You may have actually hit on something. They got a new server and everything still wotked perfectly. But then they upgraded to Office 2007. Actually on one workstation I uninstalled the Office 2007 and installed MS Access 2003 only. But it is still giving me grief.

Thanks for you help. Let me know what else I can try