Webuser Forums: Dabase in Visual Basic

Any advice appreciated here...

I want to be able to utilise a database in my Visual Basic program (version 6 Pro) but I'm getting the error "Run-time error '3015': 'xxxxx' isn't an index in this table'.

The table exists, and I've tried it in both Access and Excel formats. I'm using XP version of Office, and this is where I think the problem is. If I save the databases in XP format, they won't work in VB6Pro at all. If I save it as another format (ie. in Access saving it in Access 1997 format; in Excel, saving it in Excel 5.0 format) they work until I try to use ".Recordset.Index =" command which is what's generating the above error message.

I can utilise an already existing database saved in the above formats, but when I load up the database, then save it in the associated package, the errors return.

Is there any way I can create a new database without it generating this error?

SanderDolphin
http://www.sanderdolphin.com