debug connections

[oaishm]

How do we go about debugging connections in access when we try to link to a table.

I know this works in excel.
Provider=VFPOLEDB; Data Source=Y:\Data\EF.DBC;
and I can use the costtran table

But in access, access can't find the table. And, if you'll note, costtran is 8 characters and I've upgraded to sp2, so every googled fix has been attempted. Is there some way we can just have some visibility into the connection process because it's all a big black box.

 

[xenou]

A provider for Excel may be different than a provider for Access. I would start from scratch - google connecting Access and FoxPro, with your version of Access in the search (2003, 2007, 2010).

 

[SydneyGeek]

Try connectionstrings.com for a sample connection string.

And just possibly...
Which version of Access are you using? Access dropped support for some ISAMs in 2010.

Denis