473,695 Members | 2,464 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

#NAME? displaying in linked tables (Access 2000) after DB2 migration.

smd
Hello and thanks for taking the time to read this. I've looked all
over the web and newsgroups and can't find a solution to my problem.
I've posted this question to the Access 2000 group as well - sorry for
cross posting.

Back ground:
User at remote site has Access 2000 running on XP (don't know SP of
either). Linked tables are DB2 v8 running on AIX. All of the linked
tables are in the same database and schema.

Problem:
Some linked tables, when viewed in datasheet form from within Access,
display "#NAME?"; others do not. This problem started right afer the
database was migrated from 390 to AIX.

Things I've tried:
All obvious connectivity related trouble shooting (the server and DB
can be seen from IBM DB2 Configuration assistant and Putty, the DSN is
registered ODBC, etc.) Results: nothing out of the ordinary.

Reinstalled Msowfc.dll as suggested in KB article(not sure I spelled it

correctly here, but you get the picture) Results: no effect

Checked connection string using this command typed in the Immediate
Window: ?dbengine(0)(0) .TableDefs("CAP _UFPWK_DPTMDSC_ SLSSTK").Connec t
Results: Thought I had something here when one of the connection
strings was returned with the user's current ID, but an old password.
Had the user delete the linked table in Access (highlighting and
pressing delete key) and then set up the linked table again. Now all
connection strings are the same
(ODBC;DSN=LFPPR OD;MODE=SHARE;D BALIAS=LFPPROD; ). Unfortunately, no
effect.

I'm stuck! Anyone have similar problems? Anyone have a suggestion on
how to fix? Thanks in advance for your help!

Nov 13 '05 #1
7 3423
On 7 Oct 2005 08:23:23 -0700, "smd" <sd******@swbel l.net> wrote:
Hello and thanks for taking the time to read this. I've looked all
over the web and newsgroups and can't find a solution to my problem.
I've posted this question to the Access 2000 group as well - sorry for
cross posting.

Back ground:
User at remote site has Access 2000 running on XP (don't know SP of
either). Linked tables are DB2 v8 running on AIX. All of the linked
tables are in the same database and schema.

Problem:
Some linked tables, when viewed in datasheet form from within Access,
display "#NAME?"; others do not. This problem started right afer the
database was migrated from 390 to AIX.

Things I've tried:
All obvious connectivity related trouble shooting (the server and DB
can be seen from IBM DB2 Configuration assistant and Putty, the DSN is
registered ODBC, etc.) Results: nothing out of the ordinary.

Reinstalled Msowfc.dll as suggested in KB article(not sure I spelled it

correctly here, but you get the picture) Results: no effect

Checked connection string using this command typed in the Immediate
Window: ?dbengine(0)(0) .TableDefs("CAP _UFPWK_DPTMDSC_ SLSSTK").Connec t
Results: Thought I had something here when one of the connection
strings was returned with the user's current ID, but an old password.
Had the user delete the linked table in Access (highlighting and
pressing delete key) and then set up the linked table again. Now all
connection strings are the same
(ODBC;DSN=LFPP ROD;MODE=SHARE; DBALIAS=LFPPROD ;). Unfortunately, no
effect.

I'm stuck! Anyone have similar problems? Anyone have a suggestion on
how to fix? Thanks in advance for your help!


Hi
have you tried recreating the offending tables on the db2 side? In principle you can do this
from Access by exporting the table but I've never had much luck with that and
I usually run create table and index queries from Access to make the structure. (I find
this easier than using the IBM tools because I am not familiar with them)

Are there indexes on these tables?

I read somewhere that the coming of 64 bit windows is leading to changes in the length
of some SQL types in ODBC which I expect will lead to problems in the future if different
versions of the software are used on the two systems.
Nov 13 '05 #2
smd
Hi, thanks for your reply! I have not rebuilt the tables because there
are no other problems accessing the DB2 tables using linked Access
tables anywhere else in the enterprise - except for this user and his
team (copied the MDB and distributed it amongst themselves).

Yes, there are indexes on the tables.

Does Access keep an entry somewhere (registry) that would hold a
connection string?

If not, is it possible that upon deletion and recreation of a linked
table, the DB object is not being refreshed (does not recognize that
the link has been deleted and recreated) so that when Access is shut
down, the old link is saved? Do you think I might need to explicitly
(from the Immediate window) referesh the DB object after deletion of
the linked table and repeat after recreation?

Nov 13 '05 #3

"smd" <sd******@swbel l.net> wrote in message
news:11******** *************@g 49g2000cwa.goog legroups.com...
Hi, thanks for your reply! I have not rebuilt the tables because there
are no other problems accessing the DB2 tables using linked Access
tables anywhere else in the enterprise - except for this user and his
team (copied the MDB and distributed it amongst themselves).

Yes, there are indexes on the tables.

Does Access keep an entry somewhere (registry) that would hold a
connection string?

If not, is it possible that upon deletion and recreation of a linked
table, the DB object is not being refreshed (does not recognize that
the link has been deleted and recreated) so that when Access is shut
down, the old link is saved? Do you think I might need to explicitly
(from the Immediate window) referesh the DB object after deletion of
the linked table and repeat after recreation?

When I read the title, I was going to suggest to delete and re-build the
Access liked tables, but read that you hve done this already. Could you try
getting them to create a brand new blank database and just creating the
linkd tables? If that works, possibly rebuild the front end.
Nov 13 '05 #4
smd
Yea figured it out! Apparently deleting and recreating the linked
tables during the same session from the main DB|Tables window does not
refresh Access's underly DB object. But once I had the user install
the Linked Table Manager and select all the recently deleted and
recreated linked tables, the data magically appeared upon update. You
would have thought that something this easy would appear in a KB
somewhere!
Thanks again for the help!

Nov 13 '05 #5
On 7 Oct 2005 12:01:02 -0700, "smd" <sd******@swbel l.net> wrote:
Hi, thanks for your reply! I have not rebuilt the tables because there
are no other problems accessing the DB2 tables using linked Access
tables anywhere else in the enterprise - except for this user and his
team (copied the MDB and distributed it amongst themselves).

Yes, there are indexes on the tables.

Does Access keep an entry somewhere (registry) that would hold a
connection string?
Not so far as I am awareIf not, is it possible that upon deletion and recreation of a linked
table, the DB object is not being refreshed (does not recognize that
the link has been deleted and recreated) so that when Access is shut
down, the old link is saved? Do you think I might need to explicitly
(from the Immediate window) referesh the DB object after deletion of
the linked table and repeat after recreation?

Usually, closing and re-opening the database would force any refresh.
Does every field in the table come out as #NAME? This suggests a type mismatch.
Are fields of particular types affected?

Try to open a recordset from the table in code and copy the fields into
variables of the expected type see what error you get?

Though this shouldn't affect anything,are any of the fields renamed using the
caption property?
Nov 13 '05 #6
On 7 Oct 2005 13:29:39 -0700, "smd" <sd******@swbel l.net> wrote:
Yea figured it out! Apparently deleting and recreating the linked
tables during the same session from the main DB|Tables window does not
refresh Access's underly DB object. But once I had the user install
the Linked Table Manager and select all the recently deleted and
recreated linked tables, the data magically appeared upon update. You
would have thought that something this easy would appear in a KB
somewhere!
Thanks again for the help!


Glad this works, though I am surprised as I have often just changed the
connection strings with FindAndReplace in cases where the linked table
manager won't work and provided I close the database (and maybe compact it)
it has worked. Admtitddly this was with local tables in Access 97 days.

Nov 13 '05 #7
smd
Thanks again for your help!

Would you believe this has been an open trouble ticket since January
(it came across my desk Wednesday afternoon - since it's *obviously* a
problem with the way my predecessor defined the DB2 table)!

Nov 13 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
6771
by: Andreas Lauffer | last post by:
I changed from Access97 to AccessXP and I have immense performance problems. Details: - Access XP MDB with Jet 4.0 ( no ADP-Project ) - Linked Tables to SQL-Server 2000 over ODBC I used the SQL Profile to watch the T-SQL-Command which Access ( who creates the commands?) creates and noticed:
0
4609
by: Bon | last post by:
Hello All I got "Tables are skipped or export failed" error when I used upsizing wizard on migrating MS Access 2000 to MS SQL Server 2000. I am changing my application backend database from MS Access 2000 to MS SQL Server 2000. My front end is MS Access interface. When I used the MS Access 2000's Upsizing Wizard for database migration, some tables cannot be migrated. The upsizing wizard report states some tables are "Tables are...
6
94547
by: Max | last post by:
Hi, I have SqlServer 2000 as back end and Access 2000 as front-end. All tables from Sqlserver are linked to Access 2000. I am having write conflict problem with one of my form which is bound to a query which consist of let say tableA , TableB and TableC (all are linked tables from SqlServer. While the form is open I am modifying TableA through code on Form_AfterUpdate Event and getting the following message.
2
9459
by: Bruce | last post by:
Greetings! After finally figuring out that the Linked Table manager is no longer an add-in in Access 2003 I now discover that it does not display any of my linked tables in the 'select linked tables to be updated' list. Although I have about 30 linked tables in my application, absolutely none of them are showing up in the list. I compacted and repaired, but that didn't have any effect. Has anyone else seen this problem? If so, how is...
4
14468
by: anand | last post by:
Hi, I have an Access 2000 database, which contains some native tables, and some linked tables which belong to an ORACLE database, through ODBC. Using VB.NET, I am trying to fetch some data by joining two tables, one table native to the mdb file, and another belonging to ORACLE. I am using a connection string to connect to mdb file:
7
11831
by: Joe | last post by:
I am using Access 2003 and are linking to an Oracle 9i ODBC datasource (using Oracle ODBC drivers). After linking the tables in Access, I inspect the data contained in the linked tables. For tables that involve a number field as the primary key, the data is returned successfully. For tables that involve a character field (e.g. CHAR(3) or VARCHAR(10)) as the primary key, I have the correct number of rows returned, but the data displayed...
2
1718
by: Florifulgurator | last post by:
Hello, trying to clean up other´s mess... I´ve replaced some tables (previously linked to another Access DB) with renamed tables linked to a PostgeSQL DB (removed spaces and Ümlauts in names, secured referential integrity). There´s one (probably more) report that doesn´t get the new name:
2
6008
by: Jill Elaine | last post by:
I am building an Access 2002 frontend with linked tables to an encrypted Paradox 7 database. When I first create these linked tables, I'm asked for the password to the encrypted Paradox database, and the linked tables are successfully created. I use the data from these linked tables in several forms. All works great until I close the Access frontend and open it again. When I try to use the forms, I get an error message: "Could not...
1
1571
by: gwsmith | last post by:
I have an Access system that uses linked tables to store the data separately from the system design & code. I am trying to implement a text box to display the location of the database that the system is currently linked to to make sure I am using the right data. I am using the following expression which works fine in Access 2000, but not in 2003. Can someone please help me to update this to work in 2003? =currentdb.tabledefs("table1"). ...
0
8617
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8553
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9112
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
8822
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8815
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
5827
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4332
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
2994
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
1970
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.