{Disarmed} [belajar-access] Re: refresh linked Table Ms access 2010 dengan DBF file yg berubah-ubah

 

Runtime error 3170 "could not find installed ISAM"
timbul biasanya karena driver untuk database ( dbase iv ) yang dibuka
tidak sesuai atau belum terinstall . coba pilih driver lain , misal
Visual Foxpro Table. Coba pelajari :

http://tech.groups.yahoo.com/group/belajar-access/files/jkssbma/Link
Tabel dari Foxpro 2.6

--- In belajar-access@yahoogroups.com, Xancheel <xancheel@...> wrote:
>
> Dear Akang - akang sadaya
>
> Dah setengah harian ini coba-coba buat access dengan link ke DBF file
( database nya masih jadul bgt dah), maunya untuk reporting dan analysa
data pake access.
> nemu masalah waktu linked table dari DBF ke access. karena table DBF
nya berubah-ubah (nama filenya perperiode), jadi waktu buka access harus
direfresh dulu ke File DBF yang baru.
>
> browsing cari-cari cara refresh tablenya belum bisa juga. berkenankah
akang-akang disini ng-advice yang lagi belajar ini :
> nemu code berikut tetep gak bisa,
>
> Public Sub UnLinkMe(strTable As String)
> 'this sub deletes a table def. For linked tables it deletes the
link only!
> CurrentDb.TableDefs.Delete strTable
> End Sub
>
>
> Public Sub LinkMeUp(strTable As String, strPath As String)
> Dim tdf As dao.TableDef
>
> 'create the new tabledef
> Set tdf = CurrentDb.CreateTableDef(strTable)
>
> 'connect it to the back end .mdb file on disk
> tdf.Connect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
strPath & ";Extended Properties=dBASE IV;"
>
> 'specify the table name in the back end .mdb
> tdf.SourceTableName = strTable
>
> 'append the linked table locally
> CurrentDb.TableDefs.Append tdf
>
> End Sub
>
> pas yang terakhir "CurrentDb.TableDefs.Append tdf" pasti error terus.
Runtime error 3170 "could not find installed ISAM"
>
> kira-kira apanya kang.
>
> makasi sebelumnya.
> wassalam
> --
> A.Jamal
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 11

Visit Your Group

SPAM IS PROHIBITED

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

if(window.yzq_d==null)window.yzq_d=new Object(); window.yzq_d['oU5GPNBDRmE-']='&U=13cadnb4v%2fN%3doU5GPNBDRmE-%2fC%3d493064.14543979.14562481.13298430%2fD%3dMKP1%2fB%3d6060255%2fV%3d1';

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.