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?
|
|
