s****l 发帖数: 311 | 1 Hi, all
Recently, my boss demand me to get familiar with Access database. Any
advice on textbook selection (digital version, or traditional paper
book) will be greatly appreciated! (FYI, I have fairly good computer
background, good at Visual C++ ... have experience with SQL, Oracle 8 | xt 发帖数: 17532 | 2
Then why do you need that piece of crap? In case you really want to
learn. A book by Alison Balter is practical and nice. I digged into
VBA very much with the help from that book. But I am still not a fan
of macros.
Alison Balter also has a vidoe series called Access 97, published by
KeyStone Learning Systems Corp. It is nice too. Unfortunately she's
not a ppmm. hehe
【在 s****l 的大作中提到】 : Hi, all : Recently, my boss demand me to get familiar with Access database. Any : advice on textbook selection (digital version, or traditional paper : book) will be greatly appreciated! (FYI, I have fairly good computer : background, good at Visual C++ ... have experience with SQL, Oracle 8
| a**m 发帖数: 17 | 3 You can read documents in MSDN, got a sample application and study it.
Should be pretty easy for you if you have oracle experience. But
access
is really a crab, persuade your boss to switch to oracle or even
sqlserver,
they are much better than access.
Any
8
【在 s****l 的大作中提到】 : Hi, all : Recently, my boss demand me to get familiar with Access database. Any : advice on textbook selection (digital version, or traditional paper : book) will be greatly appreciated! (FYI, I have fairly good computer : background, good at Visual C++ ... have experience with SQL, Oracle 8
| S****n 发帖数: 46 | 4 i don't like access.
wrote a vb/asp application on access.
we even cannot use RecordCount to get the size of the recordset.
i don't know how to set cursor backwords as well as forward.
anyway, there are many restrictions in access.
it is better client than server.
【在 s****l 的大作中提到】 : Hi, all : Recently, my boss demand me to get familiar with Access database. Any : advice on textbook selection (digital version, or traditional paper : book) will be greatly appreciated! (FYI, I have fairly good computer : background, good at Visual C++ ... have experience with SQL, Oracle 8
| xt 发帖数: 17532 | 5
hehe, that is your fault. You should do this:
rst = CurrentDb.open()
rst.MoveLast()
NumRecords = rst.RecordCount
rst.MoveFirst()
rst.MoveNext
...
【在 S****n 的大作中提到】 : i don't like access. : wrote a vb/asp application on access. : we even cannot use RecordCount to get the size of the recordset. : i don't know how to set cursor backwords as well as forward. : anyway, there are many restrictions in access. : it is better client than server.
| S****n 发帖数: 46 | 6 thanks a lot.
is it true to all database? | xt 发帖数: 17532 | 7
I think it's VBA, so it only happens with Acsess.
【在 S****n 的大作中提到】 : thanks a lot. : is it true to all database?
|
|