Cc v?n ? khi b?n pht hnh l?i ?ng d?ng truy c?p nh l m?t ?ng d?ng c s? d? li?u phn chia

D?ch tiu ? D?ch tiu ?
ID c?a bi: 162522 - Xem s?n ph?m m bi ny p d?ng vo.
Nng cao: ?i h?i chuyn gia m? ha, kh? nng tng tc v multiuser k? nng.

Bung t?t c? | Thu g?n t?t c?

? Trang ny

TM T?T

Bi vi?t ny th?o lu?n v? cc v?n ? m b?n nn ?a ch? khi b?n phn ph?i l?i m?t ?ng d?ng Microsoft Access nh l m?t ?ng d?ng c s? d? li?u phn chia b?ng cch s? d?ng Microsoft Office Developer ?n b?n cng c? (ODE) ho?c Microsoft Access pht tri?n c?a Toolkit (ADT) Phin b?n 7,0 cng c?. Bi vi?t ny ?a ch? cc ch? ? sau:
  • M?t ?ng d?ng c s? d? li?u phn chia l g??
  • Vi?c t?o ra cc t?p tin ci ?t
  • Lm m?i ?c lin k?t b?ng

THNG TIN THM

M?t ?ng d?ng c s? d? li?u phn chia l g??

C s? d? li?u phn chia ny bao g?m hai c s? d? li?u t?p tin. M?t trong nh?ng c s? d? li?u (?c g?i l c s? d? li?u back-end) ch?a ch? cc b?ng bi?u v cc m?i quan h? v c tr trn m?t my ch? t?p tin m?ng. C s? d? li?u khc (g?i l cc pha tr?c-end c s? d? li?u) ch?a t?t c? cc ?i t?ng c s? d? li?u khc: truy v?n, h?nh th?c, bo co, macro v m-un v c tr trn m?i ng?i dng my tnh.

Mt s? chia r? c s? d? li?u thi?t k? lm vi?c t?t trong cc mi tr?ng multiuser, v n cung c?p nh?ng u i?m:
  • Hi?u su?t ?c c?i thi?n v? ph?n ?ng d?ng c?a c s? d? li?u, giao di?n ng?i dng, l trn ?a c?ng ?a phng c?a ng?i dng.
  • M?ng l?i giao thng l gi?m b?i v? ch? c d? li?u i qua m?ng; t?t c? cc ?i t?ng khc trong c s? d? li?u l ?a phng.
  • C?p Nh?t ?ng d?ng c?a b?n l d? dng hn. B?n c th? lm cho thi?t k? thay ?i c s? d? li?u front-end, v sau phn ph?i cc thay ?i cho ng?i dng m khng thay ?i b?t k? d? li?u trong c s? d? li?u back-end.
  • Trong mi tr?ng khng th?i gian ch?y, ng?i dng c th? t?o ring c?a h? Tu? ch?nh cc ?i t?ng, ch?ng h?n nh truy v?n, bi?u m?u ho?c bo co, m khng ?nh h?ng khc ng?i s? d?ng.
Sau khi b?n pht tri?n ?ng d?ng c?a b?n, b?n c th? t? t?o ra cc back-end c s? d? li?u, xu?t kh?u cc b?ng vo n, v sau lin k?t h? quay l?i c?a b?n m?t tr?n-end c s? d? li?u, ho?c b?n c th? s? d?ng thu?t s? Splitter c s? d? li?u trong Microsoft Truy c?p ? t? ?ng lm vi?c cho b?n.

Vi?c t?o ra cc t?p tin ci ?t

Khi b?n pht hnh m?t ?ng d?ng c s? d? li?u phn chia, t?o ra hai ring b? su t?p c?a thi?t l?p t?p tin: thi?t l?p m?t c s? d? li?u front-end v t?t c? cc t?p h? tr? c?a n, v thi?t l?p m?t c s? d? li?u back-end c ch?a ch? t?p tin v, ty ch?n, m?t t?p tin Readme.

Cc thi?t l?p cho b?n c s? d? li?u back-end khng c?n ph?i bao g?m b?t k? l?i t?t, cc gi tr? s? ng k?, ho?c cc thnh ph?n b? sung. Tuy nhin, thu?t s? ci ?t s? t? ?ng bao g?m Microsoft Access thi?t l?p t?p tin, v cc t?p s? ?c ci ?t trn my ch? t?p tin cng v?i k?t thc c?a b?n tr? l?i c s? d? li?u.

Khi b?n pht hnh ?ng d?ng c?a b?n, h?ng d?n m?t m?ng ho?c ng?i qu?n tr? h? th?ng ? ch?y chng tr?nh ci ?t cho c s? d? li?u back-end c?a b?n trn m?ng l?i t?p tin my ch? ?u tin. C?ng cung c?p h?ng d?n ? thi?t l?p cc c?p php chnh xc cho th m?c ni c tr d? li?u, ch?ng h?n nh ?c, vi?t, T?o v xo. B?n c th? bao g?m nh?ng ng?i v h?ng d?n khc trong m?t Readme t?p tin, v bao g?m cc t?p tin Readme l m?t ph?n c?a thi?t l?p cho tr? l?i-k?t thc c?a b?n c s? d? li?u.

Sau khi thi?t l?p ci ?t cc t?p tin thch h?p trn cc t?p tin h? ph?c v?, h?ng d?n cc t?t c? ng?i dng ? ch?y chng tr?nh ci ?t cho pha tr?c-end c?a b?n c s? d? li?u. Chng tr?nh ny ci ?t thi?t l?p ?ng d?ng chnh c?a b?n v t?t c? cc Microsoft Access l?n ch?y t?p tin trn m?i ng?i dng my tnh.

Lm m?i ?c lin k?t b?ng

Sau khi b?n thi?t l?p c s? d? li?u back-end trn m?t my ch? t?p tin m?ng b?n c th? c?n ph?i cung c?p m?t c ch? trong c s? d? li?u front-end ? lm m?i cc cc k?t n?i lin k?t v?i b?ng. Trong th?c t?, n l m?t ? t?ng t?t ? ch?y m?t Visual Basic th? t?c m?i th?i gian m? ra pha tr?c-end c s? d? li?u ? xc minh r?ng cc lin k?t b?ng l h?p l?, v ? lm m?i cho h? n?u h? khng. i?u ny c th? ngn ng?a ti?m nng v?n ? n?u m?t ng?i s? d?ng di chuy?n c s? d? li?u back-end vo v? tr khc, ho?c n?u cc my tnh ?a phng c?a ng?i dng khng chnh xc ?c nh x? t?i h? ph?c v? m?ng.

Cc nh pht tri?n gi?i php m?u ?ng d?ng (Solutions.mdb) i km v?i Microsoft Access ch?a m?t m-un ?c g?i l modRefreshTableLinks (ho?c RefreshTableLinks Phin b?n 7.0) m b?n c th? s? d?ng nh m?t c s? cho vn b?n c?a b?n ring Visual Basic th? t?c ? lm m?i lin k?t b?ng c?a b?n. B?n c th? th?c thi cc th? t?c trong s? ki?n OnLoad c?a h?nh th?c kh?i ?ng c?a b?n, ho?c trong m?t v? m AutoExec trong ?ng d?ng c?a b?n, do , r?ng lin k?t b?ng ?c xc minh ho?c lm m?i m?i l?n c?a b?n ?ng d?ng b?t ?u.

? bi?t thm chi ti?t v? lm th? no ? ty ch?nh modRefreshTableLinks ? s? d?ng trong ?ng d?ng ring c?a b?n, nh?p vo s? bi vi?t sau ? xem bi vi?t trong c s? ki?n th?c Microsoft:
154397Lm th? no ? s?a ?i cc m-un RefreshTableLinks trong Solutions.mdb
Chu y N?u b?n c th? thi ua topo m?ng c?a b?n ?ng d?ng c?a ng?i dng s? c, b?n khng c?n ph?i lm m?i trong b?ng, lin k?t c s? d? li?u (front-end) ?ng d?ng. V d?, n?u b?n bi?t d? li?u c?a b?n c s? d? li?u (back-end) s? n?m trn G:\MyAppFolder, ni G: l m?t m?ng ? nh x? c ? ?a, b?n th? nh x? ? ?a cng m?t cch trong mi tr?ng pht tri?n c?a b?n, v ?t c s? d? li?u back-end trong G:\MyAppFolder. Sau , khi b?n pht hnh c?a b?n ?ng d?ng, m?i b?ng k?t n?i b?t ?ng s?n s? ? ch?a cc chnh xc ?ng d?n ?n c s? d? li?u back-end. Tuy nhin, b?i v? b?n khng th? ki?m sot cho d ng?i dng di chuy?n c s? d? li?u back-end sang v? tr khc ho?c nh th? no m?i ng?i s? d?ng s? nh x? m?ng l?i c?a h? ? ?a, b?n nn bao g?m m?t th? t?c ? lm m?i b?ng lin k?t trong t?t c? cc b?n chia r? c s? d? li?u applications.

THAM KH?O

? bi?t thng tin v? vi?c s? d?ng thu?t s? Splitter c s? d? li?u, ch? m?c tr? gip t?m ki?m "C s? d? li?u Splitter."

Thu?c tnh

ID c?a bi: 162522 - L?n xem xt sau cng: 17 Thang Chin 2011 - Xem xt l?i: 3.0
p d?ng
  • Microsoft Office Access 2003 Developer Extensions
  • Microsoft Office XP Developer Edition
  • Microsoft Office 2000 Developer Edition
  • Microsoft Office 97 Developer Edition
T? kha:
kbhowto kbusage kbmt KB162522 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:162522

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