Lm th? no ? t? tch m?t truy c?p c s? d? li?u trong Microsoft Access

D?ch tiu ? D?ch tiu ?
ID c?a bi: 304932 - 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.

Bi vi?t ny p d?ng cho m?t t?p tin Microsoft Access c s? d? li?u (.mdb) ho?c vo m?t t?p tin Microsoft Access c s? d? li?u (.accdb).
Bung t?t c? | Thu g?n t?t c?

TM T?T

L? do khc nhau, b?n c th? quy?t ?nh tch ra c s? d? li?u vo m?t ?ng d?ng front-end ho?c m?t ?ng d?ng back-end. Back-end c s? d? li?u ch?a cc b?ng v ?c lu tr? trn m?t my ch? t?p tin. Cc front-end c s? d? li?u lin k?t v?i cc b?ng back-end ch?a t?t c? cc h?nh th?c, truy v?n, cc bo co, cc macro v cc m-un. C s? d? li?u front-end ?c phn ph?i ? my tr?m lm vi?c nh?ng ng?i s? d?ng.

Bi vi?t ny m t? lm th? no ? tch ra c s? d? li?u theo cch th? cng thay v? s? b?ng cch s? d?ng cc ti?n ch c s? d? li?u Splitter.

THNG TIN THM

? tch ra c s? d? li?u trong Microsoft Office Access 2003 v trong phin b?n tr?c c?a truy c?p, h?y lm theo cc b?c sau:
  1. T?o c s? d? li?u Access m?i tr?ng.
  2. Trn cc T?p tin tr?nh n, i?m ?n Nh?n ?c d? li?u bn ngoi, sau b?m Nh?p kh?u.
  3. Xc ?nh v? tr v ch?n c s? d? li?u m b?n mu?n s? chia r?.
  4. Trn cc B?ng tab, b?m vo Ch?n t?t c?, sau b?m Ok.

    Thng bo r?ng truy c?p nh?p kh?u t?t c? cc b?ng vo cc m?i c s? d? li?u, m l c s? d? li?u back-end.
  5. Lu tr? c s? d? li?u back-end m?i trn m?t chia s? m?ng v lm cho b?o ?m r?ng t?t c? ng?i dng c quy?n ?y ? v?i chia s?.
  6. T?o ra m?t m?i th? hai tr?ng Access database.
  7. Trn cc T?p tin tr?nh n, i?m ?n Nh?n ?c d? li?u bn ngoi, sau b?m Lin k?t b?ng.
  8. Ch?n c s? d? li?u back-end m b?n ch? t?o ra.
  9. Trn cc B?ng tab, b?m vo Ch?n t?t c? sau b?m Ok.

    Thng bo truy c?p lin k?t cc b?ng trong c s? d? li?u back-end ? c s? d? li?u pha tr?c-end.
  10. Trn cc T?p tin tr?nh n, i?m ?n Nh?n ?c d? li?u bn ngoi, sau b?m Nh?p kh?u.
  11. Ch?n c s? d? li?u g?c m b?n ang chia tch, v sau b?m Nh?p kh?u.
  12. Trn cc Cc h?nh th?c tab, b?m vo Ch?n t?t c?. L?p l?i b?c ny trn t?t c? cc tab ngo?i tr? cc B?ng tab. B?i v? b?n ? c lin k?t ?n cc b?ng, b?n by gi? ch? c?n chuy?n nh?p ph?n c?n l?i c?a cc ?i t?ng.
  13. Sau khi b?n ? l?a ch?n t?t c? cc ?i t?ng ngo?i tr? b?ng, nh?p vo Ok.

    Nh?n th?y r?ng b?n by gi? c t?t c? cc b?ng ?c lin k?t v ? nh?p kh?u cc ?i t?ng c?n l?i.
? tch c s? d? li?u trong Microsoft Office Access 2007, h?y lm theo cc b?c sau:
  1. T?o c s? d? li?u Access m?i tr?ng.
  2. Trn cc D? li?u bn ngoi tab, b?m vo Truy c?p trong cc Nh?p kh?u nhm.
  3. Trong cc Nh?n ?c d? li?u bn ngoi h?p tho?i h?p, b?m vo Tr?nh duy?t ? xc ?nh v? tr v ch?n c s? d? li?u m b?n mu?n tch, b?m ? ch?n cc Chuy?n nh?p b?ng, truy v?n, bi?u m?u, bo co, macro v m-un vo c s? d? li?u hi?n t?i. ki?m tra h?p v b?m Ok.
  4. Trong cc Chuy?n nh?p cc ?i t?ng h?p tho?i h?p, b?m vo Ch?n t?t c? trn cc B?ng tab, v sau nh?p vo Ok.

    Thng bo r?ng truy c?p nh?p kh?u t?t c? cc b?ng vo cc m?i c s? d? li?u, m l c s? d? li?u back-end.
  5. Lu c s? d? li?u back-end m?i vo m?t m?ng chia s?, v lm cho b?o ?m r?ng t?t c? ng?i dng c quy?n ?y ? v?i chia s?.
  6. T?o ra m?t m?i th? hai tr?ng Access database.
  7. Trn cc D? li?u bn ngoi, b?m Truy c?p trong cc Nh?p kh?u nhm.
  8. Trong cc Nh?n ?c d? li?u bn ngoi h?p tho?i h?p, b?m vo Tr?nh duy?t ? ch?n c s? d? li?u back-end m b?n t?o ra, b?m ? ch?n cc Lin k?t ?n cc ngu?n d? li?u b?ng cch t?o ra m?t b?ng ?c lin k?t. ki?m tra h?p v b?m Ok.
  9. Trong cc Chuy?n nh?p cc ?i t?ng h?p tho?i h?p, b?m vo Ch?n t?t c? trn cc B?ng tab, v sau nh?p vo Ok.

    Thng bo truy c?p lin k?t cc b?ng trong c s? d? li?u back-end ? c s? d? li?u pha tr?c-end.
  10. Trn cc D? li?u bn ngoi, b?m Truy c?p trong cc Nh?p kh?u nhm.
  11. Trong cc Nh?n ?c d? li?u bn ngoi h?p tho?i h?p, b?m vo Tr?nh duy?t ? ch?n c s? d? li?u g?c m b?n ang chia tch, nh?n vo y ? ch?n cc Chuy?n nh?p b?ng, truy v?n, bi?u m?u, bo co, macro v m-un vo c s? d? li?u hi?n t?i. ki?m tra h?p v b?m Ok.
  12. Trong cc Chuy?n nh?p cc ?i t?ng h?p tho?i h?p, b?m vo Ch?n t?t c? trn cc Cc h?nh th?c tab, l?p l?i b?c ny trn t?t c? cc tab khc ngo?i tr? cc B?ng tab b?i v? b?n ? c lin k?t v?i cc b?ng. B?n by gi? ch? c?n nh?p kh?u ph?n c?n l?i c?a cc ?i t?ng, v sau nh?p vo Ok.

    Nh?n th?y r?ng b?n by gi? c t?t c? cc b?ng ?c lin k?t v ? nh?p kh?u cc ?i t?ng c?n l?i.
Ghi ch

C s? d? li?u ny l c s? d? li?u pha tr?c-end. B?n c th? pht hnh i?u ny pha tr?c-end c s? d? li?u cho cc my tr?m ? cho m?i ng?i dng c b?n sao c?a m?nh c s? d? li?u pha tr?c-end.

B?n by gi? ? tch ra thnh cng c?a b?n c s? d? li?u, m s? c?i thi?n hi?u su?t. By gi? khi m?t ng?i s? d?ng s? m? m?t h?nh th?c, cc h?nh th?c m? t?i ?a phng trn my tnh c?a h?, v khng ?c g?i trn m?ng. Cc ch? nh?ng d? li?u i qua m?ng l cc d? li?u trong cc b?ng ?c lin k?t.

L? do t?i sao b?n c th? tch ra c s? d? li?u c?a b?n

y l l? do i?n h?nh ? chia m?t c s? d? li?u:
  • B?n ang chia s? c s? d? li?u c?a b?n v?i nhi?u ng?i dng trn m?t m?ng.
  • B?n c m?t s? ng?i pht tri?n trong c s? d? li?u v b?n khng c Microsoft Visual ngu?n Safe ?c ci ?t.
  • B?n khng mu?n ng?i dng c?a b?n ? c th? lm cho thi?t k? thay ?i ?i v?i b?ng.
Nh?ng l? do ph? bi?n nh?t ? tch m?t c s? d? li?u l b?n l chia s? c s? d? li?u v?i nhi?u ng?i dng trn m?ng. N?u b?n ch? n gi?n l lu tr? cc c s? d? li?u vo m?t m?ng chia s?, khi ng?i dng c?a b?n m? m?t h?nh th?c, truy v?n, v? m, m-un, ho?c bo co, cc ?i t?ng ny ? ?c g?i trn m?ng ? m?i c nhn ng?i s? d?ng c s? d? li?u. N?u b?n chia c s? d? li?u, m?i ng?i dng c b?n sao ring c?a h? cc h?nh th?c, truy v?n, macro, m-un v bo co. V? v?y, ch? d? li?u m ph?i ?c g?i qua m?ng l cc d? li?u trong b?ng.

Lu ? ? tch c s? d? li?u, b?n c?ng c th? s? d?ng c s? d? li?u Splitter Ti?n ch.

Thu?c tnh

ID c?a bi: 304932 - L?n xem xt sau cng: 27 Thang Tam 2011 - Xem xt l?i: 2.0
p d?ng
  • Microsoft Office Access 2007
  • Microsoft Office Access 2003
  • Microsoft Access 2002 Standard Edition
T? kha:
kbinfo kbexpertiseinter kbhowto kbmt KB304932 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:304932

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