Any suggestion on Access database learning? - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Any suggestion on Access database learning?

Any suggestion on Access database learning?# Database - 数据库

s*l2000-04-05 07:04

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

xt2000-04-05 07:04

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*m2000-04-05 07:04

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 的大作中提到】

S*n2000-04-05 07:04

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 的大作中提到】

xt2000-04-05 07:04

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*n2000-04-05 07:04

6 楼

thanks a lot.
is it true to all database?

xt2000-04-05 07:04

7 楼

I think it's VBA, so it only happens with Acsess.

【在 S****n 的大作中提到】

: thanks a lot.
: is it true to all database?