Relinking a text linked table in access97 from vb? 
Author Message
 Relinking a text linked table in access97 from vb?
How does one relink a linked txt table.
All fields end up concatenated in the first one with the general method
using RelinkMoethod

I understand a schema.ini file is needed. I cannot find any
documentation on this what so ever, how does one actually relink with
code.

Thanks in advance. ,

I'm pleading with the gods.



Sun, 18 Apr 2004 02:52:02 GMT
 Relinking a text linked table in access97 from vb?

I'm not a high-tech in this matter, but will try to help.

Try to get the "connect" property to view how it is built. Then change it
and use Refreshlink method.



Quote:
> How does one relink a linked txt table.
> All fields end up concatenated in the first one with the general method
> using RelinkMoethod

> I understand a schema.ini file is needed. I cannot find any
> documentation on this what so ever, how does one actually relink with
> code.

> Thanks in advance. ,

> I'm pleading with the gods.



Tue, 25 May 2004 20:19:32 GMT
 Relinking a text linked table in access97 from vb?


Quote:
> I'm not a high-tech in this matter, but will try to help.

> Try to get the "connect" property to view how it is built. Then change it
> and use Refreshlink method.



> > How does one relink a linked txt table.
> > All fields end up concatenated in the first one with the general method
> > using RelinkMoethod

> > I understand a schema.ini file is needed. I cannot find any
> > documentation on this what so ever, how does one actually relink with
> > code.

> > Thanks in advance. ,

> > I'm pleading with the gods.



Mon, 28 Jun 2004 05:43:50 GMT
 Relinking a text linked table in access97 from vb?

Quote:
> > How does one relink a linked txt table.

click File\GetExternalData\link tables
under files of type, select 'text files'
under filename select your test file
click Link
when the link text wizard comes up click on the 'advanced' button
click the 'save as' button and enter the name you want for the link
specification
click ok, and finish specifying the link specification

on the 'macros' tab, click 'new'.
under action choose 'TransferText'
choose your link spec from the 'Specification name' combo box
set values for transfer type, table name, and file name.
run the macro to make sure it does what you want.

in the macros window rightclick on the new macro and
select 'save as\export'
select 'save as visual basic module'

delete the link and add it back with updated connection info



Mon, 28 Jun 2004 06:09:22 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. ntext and text Datatypes- with linked SQL7 tables in Access97

2. Linked dbaseIV-file in ACCESS to be relinked by VB

3. Linked dbaseIV-file in ACCESS to be relinked by VB

4. Linked dbaseIV-file in ACCESS to be relinked by VB

5. Linked dbaseIV-file in ACCESS to be relinked by VB

6. Linked dbaseIV-file in ACCESS to be relinked by VB

7. Linked dbaseIV-file in ACCESS to be relinked by VB

8. Relinking tables, linked to Sql through ODBC

9. Access97 text import using VB 6.0

10. Access97 - Sql 7 - Memo fields on linked tables

11. DESPERATE: ADO/Access97/SQL Table Linking

12. Access97 Linked to SQL Tables


 
Powered by phpBB® Forum Software