> the error comes from databse and not from vb application can you
> still say problem is in application . thanks for reply
>
> "Erland Sommarskog" wrote:
>
>> vir (vir@discussions.microsoft.com) writes:
>> > we use an E-office application where server is SQL server 7.0 and
>> > client side its MS access
>> > In our VB program we use synchronization to update client database
>> > from server and each table is updated afresh . This program was
>> > running fine and all tables were being Updated until number of
>> > records in 1 table went above 3000 . Now this table gives overflow
>> > error while others are being updated correctly .

"Erland Sommarskog" wrote:

> vir (vir@discussions.microsoft.com) writes:
> > the error comes from databse and not from vb application can you
> > still say problem is in application . thanks for reply
> >
> > "Erland Sommarskog" wrote:
> >
> >> vir (vir@discussions.microsoft.com) writes:
> >> > we use an E-office application where server is SQL server 7.0 and
> >> > client side its MS access
> >> > In our VB program we use synchronization to update client database
> >> > from server and each table is updated afresh . This program was
> >> > running fine and all tables were being Updated until number of
> >> > records in 1 table went above 3000 . Now this table gives overflow
> >> > error while others are being updated correctly .
>
> The problem is that your description is far too vague for it be possible
> to give any useful assistance. Could you at least care to include the
> exact error message your are getting?
>
> Note that while the error message may come from SQL Server, it's not
> necessarily a problem in SQL Server, but is more likely to indicate a
> problem in the application.
>
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx