Solved

Error 3079: The specified field 'Product Code' could refer to more than one table listen in the FROM clause of your SQL statement

Posted on 2004-09-10
7
1,015 Views
Last Modified: 2008-02-01
I get this error only on the new workstations...

It has been working on 25+ computers for years.... it is not working with new computer, which has Access 2003.

Surprisingly enough, another PC, which was upgraded to MS Access 2003 doesn't have that error.
First i thought it could be a user account or permissions issue.. but i have checked with an admin account on the new PC and it throws this error:

Error 3079: The specified field 'Product Code' could refer to more than one table listen in the FROM clause of your SQL statement

Any ideas?

p.s. i have tried  reinstalling access 2003
0
Comment
Question by:jibranilyas
7 Comments
 
LVL 65

Expert Comment

by:Jim Horn
Comment Utility
Nope.  Dump the SQL statement here.
0
 

Author Comment

by:jibranilyas
Comment Utility
sorry, don't have access to that... i will c if i can get that for you...

anything that you can think ... after all, the code works in all but the new PCs.
0
 
LVL 65

Assisted Solution

by:Jim Horn
Jim Horn earned 50 total points
Comment Utility
If you don't have access to the SQL statement, then how exactly were you plainning on fixing this?
0
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 
LVL 19

Accepted Solution

by:
peh803 earned 300 total points
Comment Utility
The weird thing is that the statement "has been working for years" on other computers...

Typically, an error like this will refer to the scenario where a field name referred to in the select statement exists in more than one table and table aliases have not been used.  So, the rdbms gets confused and doesn't know which value from which table it should give you.


peh803
0
 
LVL 41

Assisted Solution

by:shanesuebsahakarn
shanesuebsahakarn earned 100 total points
Comment Utility
Well, you could also try installing the Jet SP8 service pack, but I have a feeling that's not going to make huge amounts of difference. As Jim says, if you want to troubleshoot this, you'll need access to the SQL statement that actually fails.
0
 
LVL 57

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 50 total points
Comment Utility

  Check how the ANSI 92 option is set (tools/options, tables/queries tab) between a station that does work and one that doesn't.

  If they are the same, then put a copy of the database from a station that works onto one that doesn't.  If it still doesn't work right, then it's a problem in the environment (Access install).

Jim.
0
 

Author Comment

by:jibranilyas
Comment Utility
thanks guys...

this is what i did....
being more of a PC tech, i was just curious why the same code would work on one machine and not the other when the database is same ( on the network drive )    with the ODBC connections identical as well..

Soo, i uninstalled access 2003 and installed access that came with office XP... now THAT works... i m delighted but then again... not a perfect solution...

now what i m gonna do is just upgrade access from access xp to access 2003.    FYI- one pc that was had the upgrade of access 2003 wasn't throwing that error as i mentioned in earlier post...

I will keep u posted.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now