|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 26th, 2006, 07:12 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Linked table manager
Can anyone explain why my Linked table manager would not be working when I
have some tables that are linked to other databases. I cannot see which one they are linked to nor can I update them, If I move my database. Thanks this has just started it has worked beautifully before. 
|
|
#2
January 26th, 2006, 11:42 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Linked table manager
What do you mean by 'it's not working'?
Is the option grayed out? Try deleting the tables and relinking them. -Dorian "Akrt48" wrote: Can anyone explain why my Linked table manager would not be working when I have some tables that are linked to other databases. I cannot see which one they are linked to nor can I update them, If I move my database. Thanks this has just started it has worked beautifully before.
|
|
#3
January 26th, 2006, 11:48 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Linked table manager
No they are not greyed out the manager is blank when I bring it up while
highlighting the table. The table shows the link arrow but I cannot get a reading in the manager. "mscertified" wrote: What do you mean by 'it's not working'? Is the option grayed out? Try deleting the tables and relinking them. -Dorian "Akrt48" wrote: Can anyone explain why my Linked table manager would not be working when I have some tables that are linked to other databases. I cannot see which one they are linked to nor can I update them, If I move my database. Thanks this has just started it has worked beautifully before.
|
|
#4
January 27th, 2006, 04:58 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Linked table manager
Can you open the linked tables?
Are you selecting Tools--Database Utilities--Linked table manager. If you see no links there, I'd try deleting the links and recreating them -Dorian "Akrt48" wrote: No they are not greyed out the manager is blank when I bring it up while highlighting the table. The table shows the link arrow but I cannot get a reading in the manager. "mscertified" wrote: What do you mean by 'it's not working'? Is the option grayed out? Try deleting the tables and relinking them. -Dorian "Akrt48" wrote: Can anyone explain why my Linked table manager would not be working when I have some tables that are linked to other databases. I cannot see which one they are linked to nor can I update them, If I move my database. Thanks this has just started it has worked beautifully before.
|
|
#5
January 27th, 2006, 06:03 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Linked table manager
That's what I am doing, and I have tried doing that but they still don't
show? I must have something turned off but I can't figure out what. "mscertified" wrote: Can you open the linked tables? Are you selecting Tools--Database Utilities--Linked table manager. If you see no links there, I'd try deleting the links and recreating them -Dorian "Akrt48" wrote: No they are not greyed out the manager is blank when I bring it up while highlighting the table. The table shows the link arrow but I cannot get a reading in the manager. "mscertified" wrote: What do you mean by 'it's not working'? Is the option grayed out? Try deleting the tables and relinking them. -Dorian "Akrt48" wrote: Can anyone explain why my Linked table manager would not be working when I have some tables that are linked to other databases. I cannot see which one they are linked to nor can I update them, If I move my database. Thanks this has just started it has worked beautifully before.
|
|
#6
January 29th, 2006, 02:58 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Linked table manager
FWIW - I have the same problem on four different computers. The linked
tables work properly from the Database window. The Tools Database Utilities Linked Table Manager is launched correctly, but *no* tables appear in its list. This is under Windows 2000, XP Home, or XP Pro running Access 2002 or 2003 in various combinations. I don't know whether there's a connection, but each of these computers also has Access 97, in which the Linked Table Manager works properly. I work around it by a) using a programmatic relinking routine or b) delete the tables and relink them manually. On Fri, 27 Jan 2006 10:03:02 -0800, Akrt48 wrote: That's what I am doing, and I have tried doing that but they still don't show? I must have something turned off but I can't figure out what. "mscertified" wrote: Can you open the linked tables? Are you selecting Tools--Database Utilities--Linked table manager. If you see no links there, I'd try deleting the links and recreating them -Dorian "Akrt48" wrote: No they are not greyed out the manager is blank when I bring it up while highlighting the table. The table shows the link arrow but I cannot get a reading in the manager. "mscertified" wrote: What do you mean by 'it's not working'? Is the option grayed out? Try deleting the tables and relinking them. -Dorian "Akrt48" wrote: Can anyone explain why my Linked table manager would not be working when I have some tables that are linked to other databases. I cannot see which one they are linked to nor can I update them, If I move my database. Thanks this has just started it has worked beautifully before. ********************** remove uppercase letters for true email http://www.geocities.com/jacksonmacd/ for info on MS Access security
|
|
#7
January 29th, 2006, 03:29 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Linked table manager
I am also running Windows XP Pro and Access 2003, I don't have the luxury of
the access 97 though. I wonder what the flaw is?. The links are working fine, just not the ability to change or update them with a broad swoop. "jacksonmacd" wrote: FWIW - I have the same problem on four different computers. The linked tables work properly from the Database window. The Tools Database Utilities Linked Table Manager is launched correctly, but *no* tables appear in its list. This is under Windows 2000, XP Home, or XP Pro running Access 2002 or 2003 in various combinations. I don't know whether there's a connection, but each of these computers also has Access 97, in which the Linked Table Manager works properly. I work around it by a) using a programmatic relinking routine or b) delete the tables and relink them manually. On Fri, 27 Jan 2006 10:03:02 -0800, Akrt48 wrote: That's what I am doing, and I have tried doing that but they still don't show? I must have something turned off but I can't figure out what. "mscertified" wrote: Can you open the linked tables? Are you selecting Tools--Database Utilities--Linked table manager. If you see no links there, I'd try deleting the links and recreating them -Dorian "Akrt48" wrote: No they are not greyed out the manager is blank when I bring it up while highlighting the table. The table shows the link arrow but I cannot get a reading in the manager. "mscertified" wrote: What do you mean by 'it's not working'? Is the option grayed out? Try deleting the tables and relinking them. -Dorian "Akrt48" wrote: Can anyone explain why my Linked table manager would not be working when I have some tables that are linked to other databases. I cannot see which one they are linked to nor can I update them, If I move my database. Thanks this has just started it has worked beautifully before. ********************** remove uppercase letters for true email http://www.geocities.com/jacksonmacd/ for info on MS Access security
|
|
#8
February 9th, 2006, 10:57 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Linked table manager
Re-register accwiz.dll (the one located in the same folder where Access 2003
is installed) Regsvr32 "path\ACCWIZ.DLL" See http://support.microsoft.com/?id=835519 -- Joan Wild Microsoft Access MVP Akrt48 wrote: I am also running Windows XP Pro and Access 2003, I don't have the luxury of the access 97 though. I wonder what the flaw is?. The links are working fine, just not the ability to change or update them with a broad swoop. "jacksonmacd" wrote:
|
|
#9
February 10th, 2006, 03:37 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Linked table manager
Thank you Joan!
"Joan Wild" wrote: Re-register accwiz.dll (the one located in the same folder where Access 2003 is installed) Regsvr32 "path\ACCWIZ.DLL" See http://support.microsoft.com/?id=835519 -- Joan Wild Microsoft Access MVP Akrt48 wrote: I am also running Windows XP Pro and Access 2003, I don't have the luxury of the access 97 though. I wonder what the flaw is?. The links are working fine, just not the ability to change or update them with a broad swoop. "jacksonmacd" wrote:
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Add New Field to DB | Karen | Database Design | 7 | October 19th, 2005 08:03 PM |
| Linked tables do not show in Linked Table Manager | DavPet | New Users | 3 | June 7th, 2005 02:56 AM |
| Sumif Linking to Another Workbook error #VALUE! | Tunde | General Discussion | 16 | March 4th, 2005 03:02 AM |
| Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
| Complicated Databse w/many relationships | Søren | Database Design | 7 | July 13th, 2004 05:41 AM |
Linear Mode
