I am running Access as a front end to SQL and maintain all reports and forms from a .mdb. I then release an .mde to a different location for end users to use.
Each time I release an .mde and a user attempts to run a report an "ODBC call failed" error appears. So I have to re-link tables on users pc's. The Users ODBC connections are set up the same as mine.
Has anyone any ideas why this may be happening?
Thanks
Paul
I have a new user who is trying to connect wirelessly. I set up the ODBC connection on his laptop but when he tries to run a report that uses queries looking at linked tables he gets ODBC call failed. Is it because he is trying it wirelessly. I'm just the data guy so I don't know too much about networking.
View 2 Replies View RelatedHi,
I have a standalone Access DB with 4 linking tables therein. They all point to tables that are stored in a server Access DB. I can open 3 of these tables in datasheet view without any problem, except one.
Whenever I try to open it, I am prompted following msg "ODBC call failed etc... server API error (#669) etc..."
And when I click OK to close the Error msg box, then another msg box appears with the msg: "Microsoft Access can't open the table in Datasheet view"
I've deleted the link table and recreated it. But I still can't open the table in datasheet view.
Does anyone knows what's to do? :confused:
This error comes when try to run a query in Access. Does someone knows how to fix it?
ODBC --call failed.
[Oracle][ODBC][Ora]ORA-01013:user requested cancel of current operation (#1013)
Any help on this will be greatly appreaciated. Thanks a lot.
Wil
Using Access 2003 and SQL Server 2005.
The Access database uses linked tabled to the SQL Server.
I have a 1 table query where I am trying to return data for a search form.
Here is the query:
CaseID = Forms!Search!cboCase
This works fine. However, when I try to get the query to return all records when there is no case selected using:
CaseID = Forms!Search!cboCase OR Forms!Search!cboCase is null
I get an ODBC call failed.
query itself doesn't work.
I am facing a problem with ODBC call failed error latly.The problem doesnt occur on my development PC but only on other PC's.I'm a beginer in Access, vba and I cant find a solution to make it work on every machines.
Code:
Dim qSQL As String
DATA = "#" & DatePart("m", DATA) & "/" & DatePart("d", DATA) & "/" & DatePart("yyyy", DATA) & "#"
qSQL = "SELECT Sum([IL]*[TO])" & _
"FROM PUBLIC_S INNER JOIN PUBLIC_SD ON PUBLIC_S.U = PUBLIC_SD.U " & _
"WHERE (((PUBLIC_SD.DAT)=" & DAT & ") AND ((PUBLIC_SD.ANA)='" & ANA & "') AND ((PUBLIC_SD.IA)='" & ia & "') AND ((PUBLIC_SD.AN_C)='PIMSS'));
Set Db = CurrentDb()
Set rs1 = Db.OpenRecordset(qSQL)
I have an ODBC connection to our company's data that uses Macola. I can enter criteria in the fields in Access to filter that data, but when I try to put a parameter query in such as [Enter order number:] I always get an "ODBC-call failed" message, error# 3146. Can I even solve this problem, or am I just not going to be able to actively change the criteria unless through a pivot chart or table, or by hand? Can anyone help? Thanks.
View 1 Replies View RelatedI have a query that uses an odbc table.
The query prompt for a date: [Enter Date]
After entering the date, I get error: "ODBC Call Failed"
Yet...when I set the criteria to the date I want: #01/01/2005# I can retrieve the data, no problem.
Any idea why I get the ODBC Call Faile error when prompting for the date?
Thanks....
BJS :confused:
Hi! I have a query setup that feeds off of three combo boxes on a form. It is setup to allow a user to search and calculate revenue for a selected time period by company, then department, then page. If all three or just company are selected, there are no issues running the data. However, if only company and department is selected I receive an 'ODBC--Call Failed' message. The issues seems to be stemming from the department field as I can link the department table to the main table and the query will run without error. The problem with that bandaid is that the query takes more than 15 minutes to run that way as opposed to about 2 minutes to pull more data at the company level.
Any suggestions on why this is happening or a fix that can be put in place? Any help is greatly appreciated.
I can provide more details if needed. Thanks!
When running a query in Access 2013 or 2010 we get an ODBC call failed. However when we run just the form, which the query connects to, it works just fine.
View 3 Replies View Relatedi am using access as a front end to SQL Server 2005 and link tables via ODBC.
Today when I run a query (normally works fine) I receive an ODBC Failed message box. I have tried opening each link table connected to the query and can open fine.
can anyone suggest other reasonf or this failure?
I am running a report that is built up of several backend queries.
I have identified the query that is causing the ODBC Failed message to appear, but cannot identify what is causing the problem.
I have tried to recreate the queries starting form the base query (which works fine).
Cannot anyone suggest anything?
Thanks
Paul
I Need help,
I have an access 2002 front end and I am linked to a sql server express 2005 backend and in one of my tables I am getting this error when I add a record to a work order table. The error is ODBC connection on INSERT failed on linked table.
A few strange rhings happen. It only involves customers with over (approx.) 140 work orders (there is a one to many with customer to work order). All other customers seem to be immune to this.
Also, if you go to the tables directly from a access database window, you can still add/edit or delete records, but in the form view, it gives you an error.
I have tried several things including changing code (the orgional code was set dbs= currentDB and dbs.execute("INSERT.......)
I have found similiar posting but no real direct causes. does anyone have any ideas on how to resolve this?
Thanks
Frank
Hi All....getting an "ODBC --call failed" error when trying to re-link tables in the Linked Table Manager in Access. I'm having a problem connecting to one particular Oracle database. I am able to connect to other DBs with no problem.
I can also connect to the problem database through SQL Navigator. And I've been able to connect to it in Access in the past. Any ideas?
Thanks!
I'm having to recode some old MS Access DBs so they will run in the following environments:
Office 2000 on WinXP
Office 2003 on WinXP
Office 2010 on WinXP
Office 2000 on Win7
Office 2003 on Win7
Office 2010 on Win7
When I wrote my code for Office 2000 on WinXP things were simple because directory paths were the same across all computers and I could hard code pathing when using a shell command to launch other files.
My new approach is to make a function call to the Windows registry to determine the default executable and path for opening a file based upon its extension (see apicFindExecutable in basWindows API module).
I'm able to use code to create a shell call and debug print it to the immediate window. If I put my cursor in the immediate window at the end of the shell call and hit [enter] the external file will open as desired. If I try to open the external file directly through code, I get a file not found error.
To recreate the error take the following steps:
(1) browse to files that are accessible from your computer
(2) click the PREPARE DATA AND OPEN MAIL MERGE DOCUMENTS command button
Shell function call is made by the fnOpenFile function located in the basOpenFile module. There has to be a trick here that I'm missing.
I have three cascading combo boxes that, when a selection is made, will auto-fill 3 following text fields. So I had it working just beautifully, with the data pulling from the correct columns. All of a sudden, they stopped working, and the text fields are displaying #Name? instead of the appropriate data. Nothing has changed on my form, and I have really been struggling to determine what happened and to fix it. Any help or suggestions would be welcome. Thanks.
View 2 Replies View RelatedI have 6 fields that display a price based on a combo box selection
I can get one to subtract from another but not all add up
It should also be a running total so it updates as I pick more options
And how can you get the combo baxes to start out blank they all have
selects already made when I open the form
Thanks I'm fairly new to access
Hi,
I have a table of users somthing like this:
User_ID
Name
Hobby
Favorite_Food
Blah
Blah
Blah
Users can be friends with one another and I need some way of logging this.
My 2 options (that i can see) are:
1) Putting a friends entry in the main user table then comma delimiting the User_ID's in the friend entry like so:
User_ID: 001
Name: John
Hobby: Frizbee
Favorite_Food: Cake
Friends: 002,004,010
2) Making a seperate table with multiple entries for each user like so:
User: 001
Friend 002
---
User: 001
Friend: 004
---
User: 001
Friend: 010
---
User: 002
Friend: 001
---
User: 004
Friend: 001
---
User: 010
Friend: 001
---
The database has to be handled by a web service and/or a web appliction making the comma delimited option occupy more server time breaking down the string into usable user_ID's.
But (and this is probably my actual problem) if i was to impliment my second idea, I'm not sure what I should make the tables primary key or the best way to relate it to the main user table.
My initial thought is to just have a, technicaly useless, ID be the primary key and impliment a one(User) to many(friends entries) relationship... but im a bit of an access n00b so thought i better come ask for some advice.
Thanks.
Its in the control source of the text box I want the total stored in
=Forms![Estimate Maker]!Tank.column(2)+Deck.column(2)+[Internal Valve].column(2)
The data entry setting did the job thanks much
Getting an error on the rst.Open statement of
"Method 'Open' of object '_Recordset' failed"
I am using the same code that I have used before, just tweaked some. Earlier I had an error because the ActiveX control was not checked off for the ADODB connection.
Below is the code...any ideas? THANKS!
Dim Conn As ADODB.Connection
Dim rst As New ADODB.Recordset
Dim lg As String
Dim frmOffset As String
Dim tagnm As String
Dim sql1 As String
Set Conn = CurrentProject.Connection
frmOffset = "3. Offset Printing"
lg = "PT"
tagnm = "Label22"
sql1 = "select translation from translation where lang=" & "'" & lg & "'" & "and formname=" & "'" & frmOffset & "'" & " and tagname=" & "'" & tagnm & "'"
rst.Open sql1, Conn, adOpenKeyset, adLockOptimistic
Me.Label22.Caption = rst!translation
anyone know of a reason for this error: "The save operation failed"? I attempted to edit some code and tried to save but got this error. Also been getting some out of memory errors. Not sure why though. Thanks
View 1 Replies View RelatedI am tyring to set up a query, that runs from a selected date range, to return only the records that don't meet the requirments. For example, I have four fields:
Name
Date
Attended
Required
I want to start the query from a date range usesing Between [StartDate] And [EndDate]. There are mulitpule records containing the same date. Then from there I want to return only the Names that don't attend the required number of sessions.
Ex.
Attended = 2; Required = 4; Return name
Attended = 3; Required = 3; Don't return name
Would this be possible with one query? If so, how would I go about setting up the criteria. If not then how would i link the 2 queries together?
I'm using Open Form, and setting the Where condition to a Parameter called search, so that a pop up asked for search parameter from user. If there users search fails to get any matches, a blank form is returned.
Can anyone suggest a better way to achieve this, so I can include a message to say no data found??
This is all my click event reads thus far...
DoCmd.OpenForm "FindLesseeForm", acNormal, "", "[Lessee]![LesseeName] Like [Search]", acReadOnly, acNormal
Thanks
I'm beginning to lose the will to live over this one. I've been merrily developing a large application (ADP) in Access 2000 and 2003 over the past 5 years. The size of the ADP is now around 30MB and it contains the following quantities of objects:
23 modules
424 forms (409 with modules)
296 reports (284 with modules)
My problem is that whenever I use the decompile switch and then recompile I get the dreaded "The Save Operation Failed" message on saving the code and the whole ADP is then rendered corrupt. My only option is to create a new ADP and import each object type (Modules first, then forms then reports) separately, compiling as I go. This seems to work OK but when I open a file I've been working on in Access 2000 on an Access 2003 PC it seems to decompile it by itself and then won't compact/save. Does anyone have any ideas about this? I've searched Google and can't come up with any reasonable suggestions.
Method 'Collect' of object'_Recordset' failed is the error I am getting when I try to set a record field to a form text field that has the system date set to it.
Specifically.
yrst is the recordset
I set a number of recordset fields to values on a form with no problem.
Included on the form is a field "txtNewUpdtDt". The control source is =Date()
The statement that is failing is yrst!SysUpdtDt = Me.txtNewUpdtDt
This had been working until today. I googled the error message and found a lot of hits, but none that specifically addressed my situation.
Anyone have any idea what's going on?
Thanks,
B
I am attempting to pull data from an XML file via VBA without doing the import on external data. I created a blank table called "tblHolding". In theory, my code works the way i want which is: User clicks button, file explorer opens for them to select the file, imports data to "tblHolding", and msg box saying complete.
It runs through the code but doesn't import. It errors at the below code. Also, where do i reference the table so I can append the data.Fails saying method importxml of object application failed
Code:
Application.ImportXML strPath & strFileList(intFile), 2
Code:
Private Sub Command234_Click()
Dim strFile As String 'Filename
Dim strFileList() As String 'File Array
Dim intFile As Integer 'File Number
Dim strPath As String ' Path to file folder
Dim f As Object
[code]...