Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Visual Basic 6 / Access

3 views
Skip to first unread message

Oin Zea

unread,
Mar 24, 2005, 10:08:44 PM3/24/05
to
Set dbsCC = OpenDatabase(Path & "\CC.mdb")
Set Clients = dbsCC.OpenRecordset("Clients")

At any time how can I tell how many records are in Clients?

I have read about .EOF and .BOF and .RecordCount but if 2 user are connected
to the database and one erase all records from clients then the other user
will not have a correct reading from these variables. That is why I ask how
can I tell how many records are in Clients at any time?


Sean

unread,
Mar 25, 2005, 11:34:39 AM3/25/05
to

Ideally you would want to restrict access to users to do a "mass erase
of all records".

Example:
Customer table
If I have a user click Edit on a record, I have a field in the Customer
table that is a yes/no and I set it to yes if it is already equal to
no. If the field is already set to yes I display a polite message box
that says:

"This record is currently being edited."

Now, dynamically, you could also save a network logon and date to the
table and display the message like this:

"This record is currently being edited by BOB as of 03/16/2005."

Then, if the user is hard-pressed to add notes to the record, they can
call Bob and ask how long they are going to be in the record.

Otherwise, you fall back on the who saves last wins rule.

Does this help?

0 new messages