This is just great

[fatboy2]

I have a standalone vb6 program that uses a data aware grid. The data source for the grid is an Access 97 mdb.
On one machine running 2000 professional, I have a strange issue.

I installed my program and it's mdb. The user gets a message that indicates I am trying to put a 6 char variable in a 5 position field. "Data too long for field, try inserting or pasting less data" I believe.

This was not re-produceable on other machines of the same configuration. To make a long story short, I discovered this message only occurs when the program exe is in THAT DIRECTORY. If I move it somewhere else on that same machine, it works as designed. Mind you, I am not moving the database, just the exe.

I am up and running, but would really appreciate it if anyone could share their idea on why such a thing would happen.

Regards.

 

[CajunCenturion]

I would focus my attention on the database. Very carefully, I would check the field definitions of the database that doesn't work, against one that does work - paying particular attention to the field sizes. Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[fatboy2]

The database is fine. There are not 2 databases. The database is the same one, on the same machine. Its the program, or rather the location of the program. From one certain directory, it produces the error, while from another directory, it works as designed.

I even re-copied it to both places to make sure I had an apples to apples comparison. This is all on the same machine.

 

[PraveenMenon]

Please tell me the datatype of the field.. if it is date, chek the date formats on each machine whethr they are different ...

All the Best Praveen Menon
pcmin@rediffmail.com