The LinkMasterFields property setting has produced this error: " <--- Nothing there

[AccessPower]

Hello Everyone,

I don't even know where to begin with this one. What I know so far:

1) The error is blank. It comes up with that message but nothing inside of the quotations.
2) The error happens during record navigation. If I try to goto next/previous/last/first record or if I try to perform a search.
3) The error doesn't happen all the time. I haven't figured out any special conditions under which it occurs other than what I've mentioned.

Side Note: The master and child fields have the same name. The child is on the subform of the master's form (the main form). The child field is in a local table. The master field is in an external table.



Any ideas here?

Thanks in advance for the assistance.

[orange]

Can you provide a copy of the database?
Just enough data to show the problem. Also suggest you do a compact and repair and then post in zip format.

[AccessPower]

I wish I could. There are exactly 45 tables, 92 Queries, 16 forms, and 22 reports. I am not the architect and don't know what I need to remove to make it not confidential. I don't even know where to begin.

I figured there might be someone here that may be able to deduce something.

Also, the linked database (master) is oracle. That may be useless info. Hard to get a starting point with such little info from the error.

[aytee111]

How are you navigating thru the records? I assume you are talking about the subform? What if you go to a record with a different link field value?

[orange]

OK, your set up is different than I first thought.
As aytee has suggested, we need to know what was done -the steps....
Does a different record give same result?

What exactly is your role with the database?

[AccessPower]

What was done:
The database has a main form that contains switch numbers for a power company.

The main form is linked directly to the oracle back-end. It pulls up a bunch of station information linked through ODBC.

The sub form has local tables that are stored in access.

The switch number on the subform is linked to the switch number on the main form. Data for the number is pulled from both databases.

Does a different record give same result?
I can't seem to reproduce the error on a whim. When the error happens, navigating in any way is not possible. The error keeps navigation from happening.

My copy is local, and not-shared, though. This may/may not be part of the issue.




What exactly is your role with the database?
I am an architect and developer. I typically don't fix wonky errors like this, though. Most of the databases that I work with are revamps or gui facelifts. The database wasn't created with best-practices in mind. Basically queries that are based on queries that are based on queries that are based on queries that are based on singular tables.

[orange]

Th local data is stored in the Access front end?
Do multiple users use the front end/Access?

Is there any error handling in the Access component?
Can you identify which record is involved?

My copy is local, and not-shared, though. This may/may not be part of the issue.

What does this mean exactly? You have all data locally including that normally in Oracle?
Yours is the only copy that is experiencing this issue?

[AccessPower]

Th local data is stored in the Access front end?

Yes (There is no backend Access component)

Do multiple users use the front end/Access?


Yes. No backend has been created.

What does this mean exactly? You have all data locally including that normally in Oracle?

I have a copy of the Access component to test on my desktop.

[AccessPower]

Also, when the error occurs, the subform switch number textbox displays the infamous: #Name? Error

[orange]

Has this database been in operation for some length of time or is it just now in test?

As you are probably aware next/previous/last/first need some logic to prevent going to previous from first record and/or going to next when you are positioned on last record.

It may be possible that some main form record has no "children". (guess)

[John_G]

Two things I can think of to look for.

First - might any of the records in the main form have Null values in the field you are using to link to the subform?

Second - might the connection to the Oracle server be intermittently broken for (very) brief periods, but enough to cause Access to generate an error?

[AccessPower]

Interesting. I opened up my local desktop copy and got this:

[AccessPower]

Two things I can think of to look for.

First - might any of the records in the main form have Null values in the field you are using to link to the subform?

Second - might the connection to the Oracle server be intermittently broken for (very) brief periods, but enough to cause Access to generate an error?

I am checking on both right now.

Update: I don't see any Null Values in the master; however, there are null values in the child table.

[orange]

When you click the debug option on the message, what is the code involved?

[John_G]

When you got the error above, did you click "debug" to see what line of code caused it? just as a guess, it might be due to VBA trying to navigate through a form which has no records to display (typically a subform).