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

Home Posts Topics Members FAQ

Linked tables manager in Access 2003?!

ET
Hello.

I'm trying to update links to the back end data files on machine with
Access 2003 installed,
pressing on Ctrl+Shift in order to get a database window open, so I can
start an
linked table manager, but, instead I just get the error message "Path
to the ... some path..
is wrong", and no database window opens...

Can somebody advice on how to open linked table manager in Access 2003?

Thank you!

Jan 24 '06 #1
4 4333
Gox
Try from code like this:

Application.Run "acwztool.att_E ntry"
ET wrote:
Hello.

I'm trying to update links to the back end data files on machine with
Access 2003 installed,
pressing on Ctrl+Shift in order to get a database window open, so I can
start an
linked table manager, but, instead I just get the error message "Path
to the ... some path..
is wrong", and no database window opens...

Can somebody advice on how to open linked table manager in Access 2003?

Thank you!

Jan 24 '06 #2
ET
isn't there easier way to open linked table manager?

Jan 24 '06 #3
ET
Does anybody know how to open linked table manager in Access 2003?

Jan 24 '06 #4
"ET" <ve****@yahoo.c om> wrote in message
news:11******** **************@ f14g2000cwb.goo glegroups.com.. .
Does anybody know how to open linked table manager in Access 2003?


Tools/Database Utilities/Linked Table Manager.

Keith.
Jan 24 '06 #5

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:
2
9461
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...
0
261
by: Tom | last post by:
Just updated my Access 97 db front end to Access 2003. When I open my linked table manager, it's empty and I have several linked sql tables and access tables located elsewhere on the network. I've updated several of these db front ends and the linked table manager has always been populated... This last one isn;t. Any thoughts??
0
2386
by: ericellsworth | last post by:
Hi all, I'm wondering if there's a way to remove the password Access (2003) has stored for an ODBC linked table without quitting and reopening the application. I have a set of linked tables which I update with a user's password on login using tdf.Connect, thereby keeping them from having to use the linked table manager or see the ODBC connection dialog. When a user logs out, I set the connect string back to a generic connect string...
6
7582
by: Lewis Veale | last post by:
I have an Access 2000 front-end pointing at a SQL Server backend, with around 80 linked tables and views. I frequently need to point the front-end at different versions of the back-end, and achieve this by relinking the tables and views to use a different DSN. I use the Linked Table Manager > Select All > and tick the 'always prompt for a new location' box, then click OK. It correctly pops up the 'select data source' box, from which I...
2
4321
by: Wayne | last post by:
I've just performed a reformat and reinstalled Access 2000 and 2003 and as usual the linked table manager in Access 2003 is broken ie. it doesn't show any tables. I've gone through the process of re-registering Accwiz.dll as outlined in the MS Knowledge Base and although this process has worked for me before, it hasn't worked this time. There are still no tables showing. The article in the knowledge base includes this line: "If the...
0
352
by: Javier Gomez | last post by:
I have the following problem: After updating my Access 2003 to SP1 my linked table manager is always empty. I do know that I have a several linked tables on my DB. 1- I tryed to repait my Access 2003 several times but No success. 2- This problem apears in all my Data Bases. Any help ??
2
6009
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
1592
by: sparks | last post by:
We have an older database done in access 97 and some of its reports use linked tables to another database.. it works fine when opened in access 97. One of the people using the database only has access 2003 installed and when they try to open the reports it says that it can't find the tables and they are not listed in the tables. how can I correct this without converting everything to 2003 or some such...it has to remain a 97 database.
0
8649
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
8586
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,...
1
8864
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
8838
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
7683
agi2029
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...
1
6506
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5842
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();...
1
3025
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
2
2289
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.