Hello again
I’m trying to understand why I’m getting the message below and how I can fix it.
This happens when ever I try to run a larger qry, and it pops up within a minute.
Any help would be very much appreciated
OBDC –call failed
[Oracle][ODBC][Ora][ORA-01013: user requested cancel of current operation (#1013)
Thank you
Corey
Hi, I have a front end that i have developed in access which manipulates a table stored in an oracle database. I have an ODBC connection to the oracle table.
When i open the access front end i am confronted with the
Oracle ODBC Driver Connect and am promted for username, service name and password.
My question is... Can I in any way take what is inputted into the driver connect for username and password.
For example to deactivate/activate some command buttons depending on the username that is inputted
Can anything like this be done or is this driver connect a totally individual thing?
Thanks
Hello Guy,
We use an Oracle base software called Trapeze and Microsoft Access sometime used as a front hand to access the Trapeze oracle tables.
Due to the possible dangers of allowing the users Access, Is there a way to block the users access to Administrative Tools, to create ODBC connectivity to our databases? Trapeze's security is antiquated and uses Oracle to validate accessibility. Since a user has to be created in Oracle, with update, delete, read, write, append rights, for Trapeze to work correctly, a user can connect directly to the Db through Access and make changes directly to the data, unless the ability to prevent them from creating their own ODBC connections.".
Any ideas on how to prevent them to create that ODBC connection?Thank for your help.
I have a Acces 2000 front end that links to an Oracle 9i back end. Everytime i open a form/table the ODBC dialog box appears asking for username/password/server. Is there a way to bypass this using vba code so that when the Access app starts the connection is established behind the scenes and therefore preventing the dialog box appearing.
View 3 Replies View Relatedi am using access against an Oracle DB through an ODBC driver, and when appending records to a local table, if access gets an Oracle record error "#deleted", the append query aborts. . . that's fine, but I can't figure out how to trap the error to get the rest of the records. . .
ugh! see attached graphic
thanks
sportsguy
we have Oracle 11g as main database and for viewing purpose, we have created an mdb (Access 2007) using Link tables via ODBC connection (system DSN).While querying, count queries are working fine with accurate record counts but, all select queries are not working fine. It filters and displays with wrong records. There is no issue in query building.how to get correct records through odbc connection to Oracle database.
View 3 Replies View RelatedHi All,
I'm having a strange problem happening here - I am using DSN / ODBC linked tables in AC97 to an oracle back end DB. Some tables open up fine, however for some other tables (on the same Oracle DB) when they open, AC97 displays all records as "#Deleted". They quite simply can't actually be deleted.
I also have ACXP on the same PC, so I converted a copy of the Access FE to XP, and using that converted copy, the offending tables open OK. Problem being almost all of my colleagues only have AC97 - so I really need it to work with that.
I searched the forum and read a (not so recent) post (http://www.access-programmers.co.uk/forums/showthread.php?t=44158) where a user described having a similar problem with DB2 tables, to which Pat Hartman suggested using the Linked Table Manager add-in to re-link the tables. I tried this on the AC97 DB, but the result is the same.
Can anyone help with this, or suggest anything worth trying?
NB: I am total novice with Oracle.
Thanks
John.
Oracle Express Edition, DB2 Express Edition-C, and SQL Server Express Edition.Which one would you develop for / work with if you had a choice (SQL Server, Oracle, or DB2)?I am thinking of making a database application with one of the above and the criteria is:Great support, communityRock Solid and stable; where some clients do not have a DBAFastEasy to back-up and restoreRelatively easy to program and developEasy to deploy and scaleThe general direction I am getting from a few people is leaning toward SQL Server Express. They say it is easier to work with than Oracle, (supposedly Oracle is not for the faint hearted especially when there are network issues) but Oracle is faster and maybe more stable than the others. Haven't really heard anything about DB2...MySQL is out, simply because of the price of an OEM for a desktop application that can be expanded later is too high for what I want to do.Thoughts?Thanks
View 1 Replies View RelatedI donot have much information at this time, but siiting in an Oracle fusion meeting, the Oracle reps mentioned they have a product to compete with MSAccess. Of course it runs on Oracle instead. They said Oracle had to come with a competing product because to many Access databases turn into Sql Server databases.
That is about all the info. I have right now on this. Thought it an interesting subject however.
Hi,
I know (and use) the code for using a DSN already setup on a user's PC.
But, does anyone know how do it it without the DSN alredy setup in VBA to an Oracle db?
Many thanks.
Hi,
I have made a link through ODBC to a Oracle table but when I view the table through Access 2003 I don't get the same data, some postings are dubble and others are missing. The number of rows are correct and it is also possible to create reports with a correct result.
I have also created a Form to be able to add and amend posting in the Oracle table, but the result is the same as when I just view the table, missing and dubble postings.
Any idea what could be wrong?
Thanks
My firm uses Access 2000 FEs to an Oracle 8 data warehouse.
I'm having trouble with a (native Access) query of Oracle joined tables using a text value from a combo box column, not the bound column, as part of the query criteria, not a pass-through query. I know, I know. but I've inherited it all.
The query return nothing. When I filter using specific string characters from the combo box column or a pure text criteria, the query returns data correctly.
It occurred to me that Oracle can't use the displayed column from the combo box as a query criteria. I'll try a text box tomorrow.
Any ideas?
Thank you in advance for your help.
Hi guys,
I'm just looking for some general views and opinions here and would love to know what people think; advantages/ disadvantages etc.
We have a system of spreadsheets traking various ongoing projects in our organisation which are sitting on 6 different regional servers. This poses a number of problems as you can imagine - no way of collating the data or generating reports centrally. Updates/bug fixes cannot be carried out because it would require chaning each workbook individually and so on and so on.
I am trying to make an argument to create a new Oracle based database or similar which will be held on a central server and accessed through the company's intranet.
What I'm trying to do is compile a list of the possible reasons to do this or not as the case may be. Opinions or arguments for and against would be most welcome.
Thanks
Liam
Hello Guy,
We use an Oracle base software called Trapeze and Microsoft Access sometime used as a front end to access the Trapeze oracle tables.
Due to the possible dangers of allowing the users Access, Is there a way to block the users from changing the oracle tables and only be able in MS Access to create reports and queries? Trapeze's security is antiquated and uses Oracle to validate accessibility. Since a user has to be created in Oracle, with update, delete, read, write, append rights, for Trapeze to work correctly, a user can connect directly to the Db through Access and make changes directly to the data, unless the ability to prevent them from modifying the tables and only create reports and queries that they can save.
Hi Guys,
I'm using this connection string below.
strConnection = "Driver={Microsoft ODBC for Oracle};Server=ServerName;uid=UID;pwd=PASSWORD;"
But I keep on getting this error.:
[Microsoft][ODBC driver for Oracle][Oracle]
Any ideas??
I have created a DSN with the same parameters and using the same driver and it still fails. What file should I update?
Running Access 2000.
Tried using a link table however it gives me an error saying that I must specify owner because several tables with that name exist. I hit ok and the window closes, I never receive a chance to specify owner (sys?). Is there a way around this or another way to create a table that is constantly accurate with my Oracle table?
Thanks
Hi
Can anybody advise me on how to import tables from an Oracle database into Access 97?
In addition to Access 97 I have a copy of SQL+ but don't now how to use it as yet.
Regards
Ian
Dear All,
I'm trying to link to Oracle through ODBC...everyhting is set up, and I can connect and I can also see the tables..The problem is...there are just toooo many tables in the link window!!!....
Does anybody know how to find the right table you want faster??? Or how to limit the tables that are retrieved from Oracle to just the ones I desire?
I even set up the correct Schemas to just view the tables I want...but It won't work when linking it through ODBC!..All the tables appear over and over again... And the list is just tooo long.
PLEASE HELP! I'm getting crazyyyyy :confused:
Zurvy
hi...
i have created a database link between oracle and msaccess....i am trying to access the msaccess table from sql(oracle)..
when i do a
select * from msacees_table@database_link
i am getting the desired result
but when i try to acces a specific column with in the msaccess table like
select msaccess_col1 from msacees_table@database_link
its says invalid column name....
any idea why its behaving like this ???
thanks...
I was hired to write some reports in Access 2000 for a small company (max of 6 users at a time). The database was created by someone else and he decided that moving to Oracle was the answer to some of their issues (losing data due to record locking). The guy did not know Access at all so that DB is screwed up (another issue all together). I had no problem creating the reports and they ran fine on my home and work computer. When I imported the reports into the Access DB at this company they ran fine (but VERY slow). I then got a call 3 days later from them saying the reports wouldn’t run. The owner decided to upgrade to Access 2003 to see if that would help but that created another set of new error messages. When I try to run the report it gives two messages: "can not perform action/make changes in record primary key" and "record not found". These reports are based on simple select queries. Trying to run the reports freezes the application. I even tried to open the tables and it either freezes the app or takes about 15 minutes to open. These tables are linked to Oracle 8i. The newest OBDC drivers have been installed and the newest Oracle 8I edition has been installed. Since I can run the reports in Access I assume the issue is the link with Oracle. I have very little Oracle knowledge. From what I can tell the data is stored in Oracle and Access pulls the data via the links. Has anyone experienced this? Does anyone know how to fix the issue? Your help is very much appreciated!
Using ODBC, is it possible to import only part of an Oracle dataset into Access 2007? If so, how would I do that? I have an Oracle table with 6 1/2 million records, but I onoly want to see the first 500,000 records.
If anyone can advise on how to do this, I would sure appreciate it.
Thank you!
Hi,
I'd like to transfer access-queries to Oracle. If I export access-queries, Oracle recognize these as tables and not as dynamic queries? Any idea how to solve this or does anybody know a tool to create queris in Oracle?
Thank!
Tom
I'm using the following tools/systems:
* Oracle 9i Enterprise Edition Release 9.2.0.5.0
* Microsoft Access 2002
* Access is running on a XP Professional desktop
What I'm doing at the moment is:
* Linking the Oracle tables in Access via ODBC
* Using Access to run develop & run queries against the linked Oracle tables
What I'm trying to figure out:
* What is the easiest way to export the query results to a local (on my machine) Access table?
Some of the queries return < 65000 rows, so I can export to excel & import the excel file back into access. Unfortunately this doesn't work for the bigger queries.
Suggestions?
Hi, I have a question regarding improving the performance of an Access front-end linking to Oracle tables.
Basically what I have done so far is migrate around 35 or so tables into an Oracle 9i database. After linking the tables in Access and prototyping some of the existing forms/reports/queries in Access, I noticed that the speed performance of everything was noticeably slower. Any suggestions as to how I can resolve this issue? For read online queries and reports, I understand that I can use a pass-through query to speed things up. However, all the forms need to allow for data entry and based on my understanding, the pass-through query solution would NOT work for this.
Any suggestions? Any help would be appreciated.
I'm getting an error (SQL command not properly ended) but main thing is, I can't get it to recognize the ms access db.
In a nutshell...I want to query the oracle db for a number and count, then scan a number into msaccess and have it 'find' the matching number in oracle and return the count only to ms access. More comments below between the code and here are table names for both oracle and access:
ORACLE: Table name is: batch_status bs
Field names are: batch_num and Batch size
MS ACCESS: Table name is tblbatchstatus
Field names are: batchnum and idcount
CODE in PASSTHROUGH QUERY:
select batch_num,BATCH_SIZE
from batch_status bs
(this works and selects all batch numbers and sizes from oracle)
(If I say 'where batch_num = 60024 -----this works also....)
However...when I add the below part...I get errors...it can't seem to match to access database....
SELECT tblbatchstatus.Batchnum, tblbatchstatus.Idcount
FROM tblbatchstatus;
where batch_num = tblbatchstatus.batchnum
And I want to just say: where batch_num = <<<scanned batch number>>> and return the id count.
I have written a few solutions in Access (using access 2007). Now I going to create a few new ones for my company. We use Oracle for our main database and was wondering what would be the advantages and disadvantages of using Oracle as my backend while Access is my front end?
Also, should I create the queries in Access or in Oracle?
finally, is there anything I need to do differently?
[URL]