The tables residing on an Oracle server appear from within acces to have the user id as a preface. The schema log files I was given (captured from a Unix workstation) do not include the user id prefix.
Is Unix or Oracle adding the user id as a result of a driver or setup?
Is there a way to have Access add that user id?
For example, the following from clause shows the prefix issue.
FROM EMAC_C_TYPE ' the Unix log file shows this
FROM APPLIX.EMAC_C_TYPE ' This form is needed using Access as the frontend where APPLIX is the user ID
If I don't add the user id to the table names, Oracle does no recognize the table. In most cases Oracle returns that there are more than one table by that name.