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

Thursday, December 8, 2011

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

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 (1)

Recent Activity:

New Members 9

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['C34tO9BDRmU-']='&U=13c9p7sqc%2fN%3dC34tO9BDRmU-%2fC%3d493064.14543979.14562481.13298430%2fD%3dMKP1%2fB%3d6060255%2fV%3d1';