Problem with Link Tables when converting to Access2K

[Tamer Seoud]

Hi everybody,

I'm converting a central Database from Access 97 to Access
2000. The DB has link Tables (Microsoft Fox Pro). Are
there any concerns regarding the link tables; will they be
working properely after the conversion? Will I be able to
refresh the links with no problems, putting into
consideration that the links were made in Access97?

I'm having enough troubles with the conversion so far and
I don't want to have any problems with those link tables,
especially they are the main tables. Please Advise.

Thanks a lot in advance.

 

[John Nurick]

Hi Tamer,

In Access 2000 you have to use ODBC to link to the FoxPro data.

 

[Tamer Seoud]

Are there any articles on how to use ODBC to link FoxPro
data?

-----Original Message-----
Hi Tamer,

In Access 2000 you have to use ODBC to link to the FoxPro data.

Hi everybody,

I'm converting a central Database from Access 97 to Access
2000. The DB has link Tables (Microsoft Fox Pro). Are
there any concerns regarding the link tables; will they be
working properely after the conversion? Will I be able to
refresh the links with no problems, putting into
consideration that the links were made in Access97?

I'm having enough troubles with the conversion so far and
I don't want to have any problems with those link tables,
especially they are the main tables. Please Advise.

Thanks a lot in advance.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.

 

[John Nurick]

There must be, at msdn.com or support.microsoft.com, but I don't have
links to them. Basically you go to the control panel (or Administrative
Tools in Windows 2k or later) and set up an ODBC data source for your
FoxPro data. Back in Access, do File|Get External Data|Link, select
"ODBC database(s)" under Files of Type, and take it from there.

Are there any articles on how to use ODBC to link FoxPro
data?

-----Original Message-----
Hi Tamer,

In Access 2000 you have to use ODBC to link to the FoxPro data.

Hi everybody,

I'm converting a central Database from Access 97 to Access
2000. The DB has link Tables (Microsoft Fox Pro). Are
there any concerns regarding the link tables; will they be
working properely after the conversion? Will I be able to
refresh the links with no problems, putting into
consideration that the links were made in Access97?

I'm having enough troubles with the conversion so far and
I don't want to have any problems with those link tables,
especially they are the main tables. Please Advise.

Thanks a lot in advance.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.

 

[Tamer Seoud]

Thank you very much, it worked well.

Best Regards
Tamer

-----Original Message-----
There must be, at msdn.com or support.microsoft.com, but I don't have
links to them. Basically you go to the control panel (or Administrative
Tools in Windows 2k or later) and set up an ODBC data source for your
FoxPro data. Back in Access, do File|Get External Data|Link, select
"ODBC database(s)" under Files of Type, and take it from there.

Are there any articles on how to use ODBC to link FoxPro
data?

-----Original Message-----
Hi Tamer,

In Access 2000 you have to use ODBC to link to the

FoxPro
data.

On Tue, 21 Oct 2003 14:26:17 -0700, "Tamer Seoud"

Hi everybody,

I'm converting a central Database from Access 97 to Access
2000. The DB has link Tables (Microsoft Fox Pro). Are
there any concerns regarding the link tables; will

they
be

working properely after the conversion? Will I be able to
refresh the links with no problems, putting into
consideration that the links were made in Access97?

I'm having enough troubles with the conversion so far and
I don't want to have any problems with those link tables,
especially they are the main tables. Please Advise.

Thanks a lot in advance.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.