PRB: Khng nh?n d?ng l?i "?c ?nh d?ng c s? d? li?u" khi b?n nng c?p ln Access 2000 ho?c 2002

D?ch tiu ? D?ch tiu ?
ID c?a bi: 238401 - Xem s?n ph?m m bi ny p d?ng vo.
Bung t?t c? | Thu g?n t?t c?

TRI?U CH?NG

N?u b?n c? g?ng truy c?p vo m?t c s? d? li?u Access 2000 ho?c truy c?p 2002, b?n c th? nh?n ?c m?t trong cc l?i sau y trong Visual Basic chng tr?nh c?a b?n.

N?u b?n ang s? d?ng Microsoft ActiveX Data Objects (ADO) (ho?c ki?m sot d? li?u ADO), b?n nh?n ?c thng bo l?i sau:
Th?i gian ch?y l?i-2147467259 khng ?c cng nh?n c s? d? li?u ?nh d?ng XXX
N?u b?n ang s? d?ng d? li?u truy c?p cc ?i t?ng (DAO) (ho?c ki?m sot d? li?u chung DAO), b?n nh?n ?c thng bo l?i sau:
Th?i gian ch?y l?i 3343 khng nh?n d?ng ?c c s? d? li?u ?nh d?ng XXX

NGUYN NHN

Truy c?p 2000 v truy c?p 2002 s? d?ng ?ng c ph?n l?c 4.0, t?o ra my bay ph?n l?c 4,0 ?nh d?ng t?p tin c s? d? li?u. Cc thnh ph?n my bay ph?n l?c 3.5 khng nh?n ra m?t ?nh d?ng.
  • N?u b?n ang s? d?ng ADO, b?n nh?n ?c l?i-2147467259 khi b?n c? g?ng ? k?t n?i c?a b?n Access 2000 ho?c c s? d? li?u 2002 thng qua cc nh cung c?p Microsoft.Jet.OLEDB.3.51.
  • N?u b?n ang s? d?ng DAO, b?n nh?n ?c l?i 3343 khi b?n s? d?ng Microsoft DAO 3.51 ?i t?ng th vi?n.
  • Ki?m sot d? li?u chung o khng ho?t ?ng ch?ng l?i Access 2000 ho?c c s? d? li?u 2002 v lun lun t?o ra l?i 3343 tr? khi n ?c s? d?ng theo h?ng d?n trong ph?n "Gi?i quy?t" c?a bi vi?t ny. i?u ny x?y ra v? i?u khi?n d?a trn my bay ph?n l?c 3.51 v ch? nh?n ra my bay ph?n l?c 3.51 (ho?c tr?c khi) c s? d? li?u ?nh d?ng.

GI?I PHP

? gi?i quy?t v?n ? ny, s? d?ng m?t trong nh?ng phng php sau y:
  • Ci ?t Visual Studio Service Pack 4 ho?c cao hn. (N?u b?n ang s? d?ng ki?m sot d? li?u, thay ?i c?a n K?t n?i b?t ?ng s?n ? Truy c?p 2000.)
  • Cho ADO (ho?c ki?m sot d? li?u ADO), s? d?ng cc nh cung c?p Microsoft.Jet.OLEDB.4.0.
  • ?i v?i DAO, thm m?t tham chi?u ?n Microsoft DAO 3,6 ?i t?ng th vi?n.
  • N?u b?n s? d?ng ki?m sot d? li?u chung, b?n ph?i m? m?t DAO 3,6 recordset v sau gn cho n l ngu?n g?c c?a s? ki?m sot d? li?u nh sau:
    Option Explicit
    Private daoDB36 As Database
    Private rs As DAO.Recordset
    Dim sPath As String
    
    Private Sub Form_Load()
    sPath = _
    "C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb"
    Set daoDB36 = DBEngine(0).OpenDatabase(sPath)
    Set rs = daoDB36.OpenRecordset("Customers")
    Set Data1.Recordset = rs
    End Sub
    					
  • V?n ? ny ? ?c gi?i quy?t b?i Visual Basic Service Pack 4. M?t gi tr? m?i)Truy c?p 2000) ? ?c b? sung cho cc K?t n?i b?t ?ng s?n s? cho php ki?m sot d? li?u o ? m? c s? d? li?u Access 2000.

T?NH TR?NG

V?n ? ny l?n ?u tin ?c s?a ch?a trong Visual Studio 6.0 Service Pack Service Pack 4.? thm thng tin v? Visual Studio service pack, b?m s? bi vi?t sau ? xem cc bi vi?t trong c s? ki?n th?c Microsoft:
194022 Thng tin: Visual Studio 6.0 Service Pack, g?, ? u, t?i sao

194295 HOWTO: Cho bi?t r?ng m?t gi d?ch v? ph?ng thu tr?c quan ?c ci ?t
? t?i v? Visual Studio service pack m?i nh?t, gh thm Web site sau c?a Microsoft:
http://msdn2.Microsoft.com/en-us/vstudio/Aa718353.aspx

THAM KH?O

? bi?t thm chi ti?t trn my bay ph?n l?c 4.0, tham kh?o ti li?u Access 2000.

? bi?t thm chi ti?t v? ADO v DAO, tham kh?o ti li?u Visual Basic.

? bi?t thm thng tin, truy v?n trn "Khng ?c cng nh?n ?nh d?ng c s? d? li?u" trong th MSDN vi?n m ?c cung c?p v?i Visual Basic.

Thu?c tnh

ID c?a bi: 238401 - L?n xem xt sau cng: 17 Thang Chin 2011 - Xem xt l?i: 3.0
p d?ng
  • Microsoft Visual Basic 5.0 Professional Edition
  • Microsoft Visual Basic 6.0 Professional Edition
  • Microsoft Visual Basic 5.0 Enterprise Edition
  • Microsoft Access 2000 Standard Edition
  • Microsoft Access 2002 Standard Edition
  • Microsoft Data Access Components 2.5
  • Microsoft Data Access Components 2.6
T? kha:
kbctrl kbjet kbprb kbtophit kbmt KB238401 KbMtvi
My d?ch
QUAN TRONG: Bi vi?t ny ?c d?ch b?ng ph?n m?m d?ch my c?a Microsoft ch? khng ph?i do con ng?i d?ch. Microsoft cung c?p cc bi vi?t do con ng?i d?ch v c? cc bi vi?t do my d?ch ? b?n c th? truy c?p vo t?t c? cc bi vi?t trong C s? Ki?n th?c c?a chng ti b?ng ngn ng? c?a b?n. Tuy nhin, bi vi?t do my d?ch khng ph?i lc no c?ng hon h?o. Lo?i bi vi?t ny c th? ch?a cc sai st v? t? v?ng, c php ho?c ng? php, gi?ng nh m?t ng?i n?c ngoi c th? m?c sai st khi ni ngn ng? c?a b?n. Microsoft khng ch?u trch nhi?m v? b?t k? s? thi?u chnh xc, sai st ho?c thi?t h?i no do vi?c d?ch sai n?i dung ho?c do ho?t ?ng s? d?ng c?a khch hng gy ra. Microsoft c?ng th?ng xuyn c?p nh?t ph?n m?m d?ch my ny.
Nh?p chu?t vo y ? xem b?n ti?ng Anh c?a bi vi?t ny:238401

Cung cp Phan hi

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com