473,320 Members | 2,146 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Linking MS Access to Oracle

35
Hi,

I am trying to get some tables from the oracle 10g database that I have on my machine into an access database. I used the Get External Data option in access and followed the steps in this tutorial:
http://aspalliance.com/893_Creating_an_MS_Access_2003_Front_End_for_an_Or acle_10g_Express_Edition_Database.2

For example, I tried getting the Employees and Departments tables from the hr schema. I was able to link them successfully, however when I click on them to view the data, the employees table produce the following error:

Could not execute query; could not find linked table [Microsoft][ODBC driver for Oracle][Oracle]ORA-00942: table or view does not exist (#942)

Microsoft Office Access can't open the table in datasheet view.

I deleted the data source created, gone through the same process and it worked fine. Now I am having the same problem with other tables.

What I mean is that it sometimes work fine other times it gives the error above.

I am using Access 2003 and Oracle 10g.

Please Help ..

Thanks
Sep 1 '08 #1
0 1485

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: xtanto | last post by:
Hi All, We need to develope application & report that run on windows accessing Oracle on Linux. and we use Crystal Report as reporting tool. Can Crystal Report on windows access...
0
by: tristant | last post by:
Hi All, I am the poster of the thread : 'Has anybody succesfully used VB.NET on Oracle on UNIX ? ' Some has teplied that It will be just fine. I forget to mention, we are using Crystal report...
5
by: pembed2003 | last post by:
Hi all, I have to write a C++ application to access some data from an Oracle database. I will be using gcc running on Solaris. Can you tell me how to do this if it's possible? Some sample code or...
2
by: Michael | last post by:
High there everyone, I have inherited a database with an odbc table (linking to an oracle database) , we have recently updated our operating environment to windows 2000 (access 2000). since...
11
by: DFS | last post by:
Architecture: Access 2003 client, Oracle 9i repository, no Access security in place, ODBC linked tables. 100 or so users, in 3 or 4 groups (Oracle roles actually): Admins, Updaters and ReadOnly....
1
by: noor | last post by:
HI Now a days I m building a web site using ASP.NET with Oracle 10g 10.1.0 as back hand . I have set uped the server well but when i Tried to connect through that server programaticaly from...
3
by: danish | last post by:
Hi, Can anyone tell me how to access oracle from php. Im using CentOS 4 with php4 already installed. From what I found after a bit of googling...php will have to be recompiled with oracle...
1
by: lochmant | last post by:
I have a series of about 10 test databases with about 34 linked table each. I need to create an Access 2003 database front end for each of these. I am currently trying to write a script that will...
1
by: elshaddai | last post by:
Using ODBC datasource administrator tool in WIndows XP SP2, I create Oracle Data Source and tested the Connection. The connection was successful. However, When I tried to link to the oracle database...
7
by: coolsti | last post by:
I have the task to set up an application at work,using MS Access as a front end to a MySQL database. This will be done using an appropriate ODBC driver, and linking the MySQL database to Access. ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.