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! 7 3425
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.
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?
"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.
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!
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?
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.
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)! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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:
|
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...
|
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.
|
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...
|
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:
| |
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...
|
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:
|
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...
|
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").
...
|
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,...
|
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...
| |
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...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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();...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |