×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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

ODBC Connection With Access

ODBC Connection With Access

ODBC Connection With Access

(OP)
I have an Access table linked with MAS 90 through an ODBC connection. I need to pull in data for multiple companies but once I enter the login and password information for the first company it no longer prompts for a new log in. How can I set the connection up so that it pulls in the data for the AP_InvoiceHistoryHeader once I enter the username and password and then when refreshed it prompts for a new log in so I can switch companies. I know this is a simple problem for someone. Thanks

Here is my connection

ODBC;DSN=SOTAMAS90;Description=MAS 90 4.0 ODBC Driver;Directory=M:\mas90;Prefix=M:\mas90\SY\, M:\mas90\==\;ViewDLL=M:\mas90\Home\;CacheSize=4;DirtyReads=1;BurstMode=1;StripTrailingSpaces=1;SERVER=NotTheServer;TABLE=AP_InvoiceHistoryHeader


Windows XP
Mas 4.3
Access 2007   
Replies continue below

Recommended for you

RE: ODBC Connection With Access

(OP)
Please explain further. When I try to link to another access database it will only show you unlinked tables. Basically, if you have a table in the secondary database linked to MAS it will not show it as an option.

RE: ODBC Connection With Access

Make another ODBC connection with a different name and using another company in the connection string.

RE: ODBC Connection With Access

What you are describing has to do with Access.  It saves you the hassle of having to re-enter the password.

If I understand what you are trying to accomplish, you want to extract data and re-join the muliple companies back into a single table.

If so I have done this before.  You would want to have multiple link tables - all using different silent DSN's.  For example, APInvHistHeader (company A), APInvHistHeader (company B), APInvHistHeader (company C).  

A silent DSN is one where you would supply it with a company, username, and password.

Then you can use a union or series of append queries to join them into a single table.

Drew Storm
MBSG

"Life is more important than... "

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