Binh Thai wrote:
> Ch?o c?c b?c xin h?i m?nh ?ang l?p tr?nh tr?n MS Access v? m?nh ??
> chuy?n sang OpenOffice 3.0 n? ko ch?y, xin h?i c? ph?n m?m n?o thay
> th? MS Access ko?
>
B?n ?? mong ??c 1 vi?c m? n? kh?ng th? x?y ra. Tr??c h?t b?n c?n ph?n
bi?t r?ng:
- engine database c?a MS Access ho?n to?n kh?c v?i engine database c?a OO
- ng?n ng? d?ng trong 2 h? th?ng c?ng ho?n to?n kh?c nhau
- c?c library m?c h? th?ng c?ng ho?n to?n kh?c nhau
Tr? l?i c?u h?i c?a b?n: mu?n chuy?n t? Access sang OO:
- v?y b?n ??nh chuy?n c?i g? ?
a) chuy?n to?n b? 1 ch??ng tr?nh (???c hi?u l? bao g?m data l?u
trong Access DB v? c?c form giao di?n, c?u truy v?n SQL, b?o bi?u) sang OO
b) chuy?n data v? vi?t l?i ph?n giao di?n tr?n OO
c) ch? chuy?n 1 CSDL l?u trong Access sang l?u trong OO base
T?i ch?a th? d?ng OO Base nh?ng v? m?t l? thuy?t (?t nh?t l? l? thuy?t
??) th? vi?c chuy?n ??i l? ho?n to?n kh? thi, c? th? :
- b?n c?n t?m c?ch chuy?n ??i data sang 1 d?ng trung gian m? c?
Access v? OO base ??u c? th? truy xu?t v? d? d?ng text delimited cho
to?n b? c?c b?ng d? li?u (table)
- ph?n giao di?n tr?n Access (c?c form m?n h?nh) t?i e l? kh?ng
th? chuy?n t? ??ng v? b?n s? ph?i x?y d?ng l?i ch?ng, t?i cho r?ng l?m
l?i c?c form ?? tr?n OO Base c?ng kh?ng c? g? qu? kh?. L? do kh?ng th?
chuy?n tr?c ti?p v? c?c ph?n t? c?a form ??u d?a tr?n nh?ng th? vi?n
controls c?a Windows do ?? mang ch?ng qua Linux l? 1 vi?c kh?ng th?,
ngay c? b?n d?ng b?n OO Base ch?y tr?n Windows t?i ngh? l? c?ng kh?ng
th? v? th? vi?n control cho UI c?a OO ch?c kh?ng d?ng c?a Windows.
- ??i v?i c?c b?o bi?u c?ng v?y
- c?c report c?ng th? m? th?i
Cho n?n tin bu?n l? b?n ch? c? th? chuy?n d? li?u thu?n v? t? x?y d?ng
l?i c?c th?nh ph?n kh?c t? d? li?u mang sang.
??i v?i 1 ph?n m?m kh?c thay th? MS Access ngo?i OO Base th? b?n c? th?
xem Kexi ( xem b?i gi?i thi?u v? Kexi ? ??y:
http://www.linux-mag.com/id/7176/)
T?t nhi?n ??ng hi v?ng n? l? 1 thay th? ho?n to?n nh?ng g? b?n ?ang c?
tr?n Access b?i v? th?c t? l? 2 platform ho?n to?n kh?c nhau. (t?i ?ang
??nh vi?t 1 c?i review ng?n ng?n v? Kexi n?y khi c? th?i gi?n test k?)
> ??ng b?o l? d?ng L?p tr?nh ASP, VB g? nha, m?nh ?ang l?p tr?nh tr?n MS
> Access,
> C?m ?n m?y b?c.
>
APS hay VB g? c?ng kh?ng m? c? li?n quan v? scripting engine c?a MS
Access l? Visual Basic for Application (VBA ) ;p
Nh?ng n?u OO hay c?i g? m? mu?n l?m ???c nh? Access th? e r?ng c?ng ph?i
??ng ??n ch?t code, m? c?i g? code ???c th? ?t c? ng?n ng? c?a n?
PS: nh? nh?ng g? b?n n?i th? t?i ?o?n b?n l?m ?ng d?ng tr?n access th?ng
qua c?c wizard c?a n? v? ch? k?o & th? ;)
