End user report and Access 2000

rbuser

Hi!
I have tried your ADO "EU report" demo with Access 2000 with poor result. I
do use ODBC express instead but ADO will be ok when I can reproduce clean
example with your demo.
So, if you could send me one "EU report" demo with ADO connection which is
Access 2000 compatible!
Thx

Damir Vadas, dipl. Ing

P.S:
I have tested this unit on Oracle 8.1.7 and BDE connection with success. I
have also submit to you some improvements for saving large reports...

digitalmetaphors

Please do not cross post!

I ran our demo yesterday with Access 2000. It worked fine. I it up and
wokring again from scratch today on a different machine:

Delphi 6
RB 6.03 - no patches applied
Access 2000
Win 2K machine:

Here are the steps I had to do this morning to get it working on my other
machine:

1. Launch Access 2000 to access Northwind Traders database.

2. Connect to Northwinds-Could not connect because it wasn't installed.

3. Install Northwinds at the prompt from the Office 2000 cd.

4. Opened Northwinds database from access when install completed.

5. Select File | Get External Data | Import

6. Choose C:\Program Files\Borland\Delphi6\RBuilder\Demos\EndUser
Databases\Access 97\rbTables42.mdb

7. Select rbField, rbFolder, rbItem, rbJoin and rbTable in the list of
tables in the Import Object dialog.

8. Click OK to close the Import Objects dialog.

9. Close Access.

10. Open C:\Program Files\Borland\Delphi 6\RBuilder\Demos\End User
Databases\Access 97\2. ADO\EndUser.dpr

11. Double click ADO connection on form

12. Choose Build.

13. Test Connection

14. Close the dialog.

15. Go back to form.

16. Select on eof the tables components.

17. Set Active property to true in object inspector to test connection.

18. Build project and run.

Created new report from report explorer, created a query dataview, saved the
report to database, loaded it back up. Works just fine here.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Hi!
I did the same copied from the CD (T:\PFILES\MSOFFICE\OFFICE\SAMPLES, where
T is my CD ROM device) and copied "Nwind.mdb" database to HDD (once more to
be sure). I did reinstall RBuilder 6.03 (to be sure).

I import rb tables and start demo! And....problems!

When you try to put two tables you get an error (pictures attached in file).

My configuration is:
I have Win2k SP3, with D5 SP2
MDAC version: 2.60.6526.3
MS Jet 4 SP 6

So please tell me what is wrong...MDAC...MS JET or....ME!??????

THX!

digitalmetaphors

Before running RB, can you see the rb tables from Access 2000?


Cheers,

Jim Bennett
Digital Metaphors

rbuser

I just did install newest MDAC and now I have: 2.70.9001.0 but the problem
is still remain!
I want to remind you that I have successfully developed Oracle/BDE version
of the same EU without any problems...but here I'm helpless!
THX!
P.S.
Please forgive for last mail with attachment, but pictures speak more then
words!

rbuser

YES!

rbuser

Here is from MS site about that error!
OLEDB Error: Either BOF or EOF is True, or the Current Record Has Been
Deleted; the Operation Requested by the Application Requires a Current
Record
The information in this article applies to:
Microsoft Windows Media Rights Manager 1.0
Symptoms
After you edit a media item and save the changes, the following error
message occurs:

OLEDB Error: Either BOF or EOF is True, or the current record has been
deleted; the operation requested by the application requires a current
record.
Cause
This error occurs when you edit an existing media item, select Create a new
key group under the Advanced options, specify a key group name, and then
click Save.
Workaround
To resolve this problem, delete the media item and add it again specifying
the new key group.
Status
Microsoft has confirmed this to be a problem in Microsoft Windows Media
Rights Manager version 1.0.
First Published:Jun 18 1999 10:17AM
Keywords:kbbug netshow drm wms

rbuser

Solution from (http://info.borland.com/devsupport/delphi/mdac26.html):
DELPHI DEVELOPER SUPPORT
MDAC v2.6 "Either EOF or BOF is true." error with ADOExpress

This update corrects a known issue which affects certain ADOExpress
applications when running against MDAC 2.6. Most commonly, the following
error is generated when closing an empty dataset: "Either EOF or BOF is
True, or the current record has been deleted. Requested operation requires a
current record". The same error may also occur when canceling an edit
operation. Affected applications should be recompiled after the update is
installed.



REQUIREMENTS

Delphi 5, Enterprise version

a.. Update Pack 1
Delphi 5, Professional version with the ADOExpress upgrade

a.. ADOExpress for Delphi 5 Professional, Update Pack 1
b.. Delphi 5 Professional, Update Pack 1
INSTALLATION

The update is a self-extracting, self-executing file. Because it refreshes
the ADO files in your current installation, Delphi must be closed before
running the update.

digitalmetaphors

Thankyou for posting your solution!


Cheers,

Jim Bennett
Digital Metaphors

rbuser

No probs!
Your RB is wonderful tool, so a little thank is always welcome. At least for
me!
Regards,
Damir Vadas