Error "Unrecognized Database Format"

[DORI]

Dear All,
Newbie Access .mdb
I am trying to create a database (Table1) with Access 2003 Professional on
my XP PC.
The Table1 includes 80 fields and one row. I need to read and write 'Texts"
to the Table1. I have set the maximim length of the record cells to 250
characters. There are 2 problems:
1) I can open Table1 directly with MS Access, but when I try to access the
Table1 through my vb6 application, there is an error message at the start up
of the application stating "Unrecognized database format" followed with my
application path\Table1.mdb.
2) When I open the Table1 with MS Access, I can insert text with 250
character-long in only a few of the resords. The rest of the records would
accept only shorter texts (i.e 46 characters vs 250) or gives another error
"Record too long"
Any idea what I am doing wrong?
All your comments are much appreciated in advance.
DORI

 

[John W. Vinson]

Dear All,
Newbie Access .mdb
I am trying to create a database (Table1) with Access 2003 Professional on
my XP PC.
The Table1 includes 80 fields and one row. I need to read and write 'Texts"
to the Table1. I have set the maximim length of the record cells to 250
characters. There are 2 problems:

There are more problems than that. Your table design IS JUST PLAIN WRONG. You
have eighty texts - this should be 80 *records*, not 80 fields! For one thing,
an Access table record is limited to 2000 bytes actually occupied; you'll get
a fatal error when you add the eighth field.

1) I can open Table1 directly with MS Access, but when I try to access the
Table1 through my vb6 application, there is an error message at the start up
of the application stating "Unrecognized database format" followed with my
application path\Table1.mdb.

Sounds like the database is corrupt, or the VB6 connection is incorrect.

2) When I open the Table1 with MS Access, I can insert text with 250
character-long in only a few of the resords. The rest of the records would
accept only shorter texts (i.e 46 characters vs 250) or gives another error
"Record too long"
Any idea what I am doing wrong?

Mis-structuring your table.


John W. Vinson [MVP]

 

[DORI]

Hi John,
Thanks very much for the directions. I modified my table per your advice and
it seems it is working well now.
DORI