Refreshing links of an MDB

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Ivan Debono (ivanmdeb_at_hotmail.com)
Date: 02/24/04 

Date: Tue, 24 Feb 2004 08:16:35 +0100

Hi all,

Is it possible to refresh the path of linked tables using ADO?

I've tried updating the records in MSysObjects but I don't have permission
:(

Thanks,
Ivan

Relevant Pages

  • Re: Refreshing links of an MDB
    ... Is it possible to refresh the path of linked tables using ADO? ... I've tried updating the records in MSysObjects but I don't have permission ...
    (microsoft.public.vb.database.ado)
  • how to check if table exists in Access with ADO?
    ... I need to see if a table exists in Access using ADO. ... "Select Name from MSysObjects Where Name = 'myTable'" ... But I got an error message that I don't have permission to ... But I can query MSysObjects from within ...
    (microsoft.public.vb.database.ado)
  • how to check if table exists in Access with ADO?
    ... I need to see if a table exists in Access using ADO. ... "Select Name from MSysObjects Where Name = 'myTable'" ... But I got an error message that I don't have permission to ... But I can query MSysObjects from within ...
    (microsoft.public.access.modulesdaovba)
  • Re: how to check if table exists in Access with ADO?
    ... ADO is only half the story. ... the ADOX library so you can examine the Tables collection of the Catalog. ... It should be possible to read MSysObjects though (unless you are blocked by ... > But I got an error message that I don't have permission to ...
    (microsoft.public.access.modulesdaovba)
  • Re: MSysObjects
    ... I don't think you will be able to write to MSysObjects. ... The usual way to do this is to loop through the TableDefs collection. ... Allen Browne - Microsoft MVP. ... This however does not work since i do not have the right permission to ...
    (microsoft.public.access.formscoding)