Search:

I have connected a datagrid to a recordset having multiple fields.
on entering value in One of the column of the datagrid and pressing enter
it gives a message (not error) automatically

Multiple...

One more thing, Is not there any way to set
connection time out or command time out in Crystal Report.

Anyway,
Thanks for the Help.
Thanks a lot.
I m going for the change of database design.
Thanks once again.

Atually Many of all are text fields.

Actually Its an application for managing Company Details with Customers
One of my client has too many records in his Company data, so this problem is comming...

ConnectionString :-
Provider=MSDASQL.1;Password="";Persist Security Info=True;User ID=sa;Data Source=XYZ;Initial Catalog=XYZ


and the SQL statement is

SELECT t1000006.*, t1000007.cus_code...

In the same system where I am executing the program

But how can I set it in the Report.
I have already set
ConnectionTimout = 300
and CommandTimeout=300

I m viewing using Embeded Viewer within VB using DSR(Report file) file.

This error is occuring when there are too many records present in the tables.
for less records it doesn't show any error...

I m working on a VB project with MS SQL SERVER 2000 as backend database and Crystal Report 8 for Reports.
The problem is :

When showing a report, after some moments error comes as

Microsoft...

I m working on Multiuser VB Project with MS Access as Database.
I just want to check (from codding) how many users are currently accessing
the backend database .
Is there any way ???

Actually in an application (VB 6 & CRYSTAL REPORT 8) I got a problem with RTF Export option. The settings (Tab settings, Paragraph settings etc.) got changed in RTF file.
One more thing is that,...

u can use the connection string

dim CNN as new ADODB.connection
CNN.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\Server\datadir\datafile.mdb;Persist Security Info=False"

I have found it , using the following bold code.






Private Sub Command1_Click()
CNN.BeginTrans If Not VALIDATE() Then Exit Sub
Call GENERATE_EMP_ID

I am using MS Access database by a vb6 program for multiuser environment.
In the program I have written code for autogenerating employee_id which is primary key in the table.
When entering records...

I have done my work using the above one.
but I just want to know is there any other method or technique to use
MS Access DB without using path.

I am using an Access Database through Visual Basic 6.
Is there any other way to access the database excluding the following code.

Set CNN = New ADODB.Connection
str = "\\SYS8\DATAX\EMP.MDB"...