Getting error Run-time error '3709' on one computer but not the other

[AAAndy]

Getting error on one computer but not the other


MS Access file is on a server so both computer access the same files from the server.

Debug statement highlights this code: DoCmd.TransferDatabase ........................

Below is the full error. Does anyone know the fix?

Run-time error '3709':
The search key was not found in any record.

[orange]

Just curious, but can you show that a record with the search key does exist?
Have you used google/bing to research error 3709?

Such a message is really an information item.

Similar, I'm searching for "ABCD", and that string doesn't exist; so an info message - search key not found in any record.

What exactly was the search key?
What exactly is the code requesting the search?

[AAAndy]

Just curious, but can you show that a record with the search key does exist?
Have you used google/bing to research error 3709?

Such a message is really an information item.

Similar, I'm searching for "ABCD", and that string doesn't exist; so an info message - search key not found in any record.

What exactly was the search key?
What exactly is the code requesting the search?

It searches for the same record each time.
I spent several hours searching on google.

I think that it might be a setting in access or the computer since it works on one but not the other.

[andy49]

Could we see the rest of the line Andy?


Sent from my iPhone using Tapatalk

[AAAndy]

I currently don't have access to the other computer. Will need to wait till Tuesday.
It is the same code / same file because it is on the server. Both computers access the server to run the file.

[Micron]

As long as they are both trying to work with the same Access database and both are using the same Excel file, I'm going to guess one of them does not have the location of either the db or Excel file set as a trusted location.
If it happened on both (or if the workbook files are not the same) I'd say one of the workbooks has a space in front of one of the column headers. Probably not real noticeable in Excel, but Access will choke on it with this error number as the result.

[AAAndy]

As long as they are both trying to work with the same Access database and both are using the same Excel file, I'm going to guess one of them does not have the location of either the db or Excel file set as a trusted location.
If it happened on both (or if the workbook files are not the same) I'd say one of the workbooks has a space in front of one of the column headers. Probably not real noticeable in Excel, but Access will choke on it with this error number as the result.

I made sure that the directory is trusted but same issue. All workbook files are also on the same server.

Below is the code that generates the error

DoCmd.TransferDatabase acExport, "Microsoft Access", Me!txtDirectory & Me!txtFileName, acTable, strQueryName, "MonthEnd", False

[Micron]

Posting the code is good but the actual values would help. Post the debug.print results from the immediate window and use code tags for code. This site inserts a space after 50 contiguous characters, which can imply problems with spaces where none exist.

[AAAndy]

Posting the code is good but the actual values would help. Post the debug.print results from the immediate window and use code tags for code. This site inserts a space after 50 contiguous characters, which can imply problems with spaces where none exist.

Itsdfkj
asdfklj skdlfj

It is fixed now. I needed to setup an ODBC SQL Server connection.