OraFAQ Forum: Forms » Connecting MS-Access through Developer 2000 forms

Home » Developer & Programmer » Forms » Connecting MS-Access through Developer 2000 forms

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Connecting MS-Access through Developer 2000 forms [message #77725]

Wed, 07 November 2001 20:29

Asish Das
Messages: 2
Registered: November 2001

Junior Member

how to connect MS-ACCESS database in through Oracle Developer-2000 forms

----------------------------------------------------------------------

Report message to a moderator

Re: Connecting MS-Access through Developer 2000 forms [message #77734 is a reply to message #77725]

Thu, 08 November 2001 09:29

Clint Garrett
Messages: 2
Registered: November 2001

Junior Member

Can't be done. Oracle forms only work on oracle database. Sorry

----------------------------------------------------------------------

Report message to a moderator

Re: Connecting MS-Access through Developer 2000 forms [message #77771 is a reply to message #77725]

Thu, 15 November 2001 09:19

Surendra K
Messages: 8
Registered: September 2000

Junior Member

Hi Ashish,

Create an ODBC through control panel - > ODBC and use Microsoft Access Driver to establish connectivity to the directory where your Access Database file is stored.

In Forms Developer use Procedures and functions of EXEC_SQL package to connect,retrieve the records from MS Access. After retrieving these use the normal Insert command to insert into Oracle database. Go through Forms help for more details.

I hope u got an idea.

Let me know and if required i can send you the code.

Cheers.
Surendra

----------------------------------------------------------------------

Report message to a moderator

Re: Connecting MS-Access through Developer 2000 forms [message #77781 is a reply to message #77725]

Fri, 16 November 2001 20:14

Asish Das
Messages: 2
Registered: November 2001

Junior Member

Dear Surendra,
sorry i could not establish the connection. Kindly send me the codes for
reference.
Thanks a lot.
Asish

----------------------------------------------------------------------

Report message to a moderator

Re: Connecting MS-Access through Developer 2000 forms [message #78564 is a reply to message #77725]

Sun, 03 March 2002 17:52

James
Messages: 120
Registered: June 2000

Senior Member

Oracle forms will work with any level 2 ODBC compliant database, no?

I'm working on creating a database link to the access and SQLSERVER 7 that my venders use so I can just use the select * from name@odbc_database_link. I'm having problems setting up the name and listner. any input would be appreciated

Report message to a moderator