×
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!
  • Students Click Here

*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

Jobs

How can i connect MS Access database to WebFOCUS?

How can i connect MS Access database to WebFOCUS?

How can i connect MS Access database to WebFOCUS?

(OP)
im currently having a problem of connecting MS Access database to WebFOCUS. Im suppose to produce reports using WebFOCUS that gets its data from an Access database. it seens that WebFOCUS doesn't detect the MS Access database. kindly reply on how i should approach this problem..thanks you

RE: How can i connect MS Access database to WebFOCUS?

Create an ODBC data source for Access and create a synonym for it.

There are different ways to create a synonym. One way is
to go to the WebFOCUS server console and creat it from there. The console looks different depending on release, but look for adapters.

RE: How can i connect MS Access database to WebFOCUS?

(OP)
i tried what u had suggested, but i have a problem, what will i type the 'owner' text box and the other text box? i already made my odbc connection name 'localDSN' with the access table name 'tempdb'

RE: How can i connect MS Access database to WebFOCUS?

What release of WebFOCUS are you using ?

RE: How can i connect MS Access database to WebFOCUS?

(OP)
im using webfocus 436

RE: How can i connect MS Access database to WebFOCUS?

(OP)
what can u suggest for me to do in order for me to make it work with MS access

RE: How can i connect MS Access database to WebFOCUS?

Did you try leaving the Owner text box and the Table Name text box empty and clicking the Select Tables button?  This should let you see everything in Access.  What error are you getting?

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