VBA, Why Does Everything become #Name?

Why Does Everything become #Name?

Author	Message
HZ #1 / 3	Why Does Everything become #Name? Hi There, I am using a Linked table which links to Oracle 8.1.5 in Access 2000. The phenomena is that when I cancel a replace all action of Find & Replace dialog box, the datasheet became only one record with everything is #Name. Why is that? Any thought to this will be appreciated. Haibin
Fri, 18 Oct 2002 03:00:00 GMT

Neb #2 / 3	Why Does Everything become #Name? HZ, I found a similar "feature." If I add a new record in a Oracle linked table, it shows #Deleted. But if I close the table and reopen it, it is still there. I think the problem lies in the ODBC drivers somewhere. -- Neb Quote: > Hi There, > I am using a Linked table which links to Oracle 8.1.5 in Access 2000. > The phenomena is that when I cancel a replace all action of Find & Replace > dialog box, the datasheet became only one record with everything is #Name. > Why is that? > Any thought to this will be appreciated. > Haibin
Sat, 19 Oct 2002 03:00:00 GMT

Tony Toew #3 / 3	Why Does Everything become #Name? Quote: >I am using a Linked table which links to Oracle 8.1.5 in Access 2000. >The phenomena is that when I cancel a replace all action of Find & Replace >dialog box, the datasheet became only one record with everything is #Name. >Why is that? Just guessing, really far out actually, but it appears that Access requires a primary key or a datetimestamp field on each table. There's a Knowledge Base article on this topic. Tony ---- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm VolStar http://www.volstar.com Manage hundreds or thousands of volunteers for special events.
Fri, 25 Oct 2002 03:00:00 GMT

Page 1 of 1

[ 3 post ]