Question

Access DB for Forms lookup

Forms

Updated May 30, 2019

asked on November 12, 2014

What are our options if the required lookup data is in an MS Access DB (since Forms only allows MS SQL or Oracle as Data Sources)? Is the only option available to have the Access DB imported into SQL and then set up their Access to act as a front to SQL for their on going interface to the DB?

0 0

Answer

APPROVED ANSWER

replied on November 12, 2014 • Show version history

Might be worth a shot trying it as a Linked server. Direction look pretty similar to current SQL versions.

http://www.aspfree.com/c/a/microsoft-access/configuring-a-linked-microsoft-access-server-on-sql-2005-server/

After it is linked you should be able to just make a view that can access it.

1 0

Replies

replied on May 30, 2019

Is this still the case that Forms can only ODBC to SQL or Oracle?

We are using MS Access to house an application we're building, and want to grab data from it in Forms, likewise send data to it from Forms. I know I can do it with workflow because I have, but it appears that Forms only likes to play with SQL. Unless I'm missing something.

0 0

replied on May 30, 2019

Forms can now use any data source present on the server. See help file for more info (same caveats about the driver matching the CPU architecture of Forms as in Workflow apply). You'll likely need Microsoft Data Access Components installed on the Forms server to play with Access.

0 0

replied on May 30, 2019

Fantastic!!

We had to do that for workflow too. I guess I thought since that was already set up on the server, Forms would see it too.

Thank you, Miruna! ;)

Roz

0 0

You are not allowed to follow up in this post.

Question

Question

Access DB for Forms lookup

Answer

Replies

Sign in to reply to this post.