One more with problems with vb6.0 and access 2000

Hello!
I know this problem has been talked about here earlier but I'm still not getting any data from a Access 2000 database. I use Microsoft.Jet.OLEDB.4.0 and I have downloaded SP5 and MDAC 2.8.

The program uses data stored in a Access database. The database was given to me on a floppy and I don't know which version of Access it was made with. As long I use the orginal database everything works fine, but when I add something to the database using Access 2000, the program won't work. I have tried to convert the file to a prior version with Access but it still doesn't help.

Could someone please tell me what to do? What references do I need and so on...

Thanks!

Can u tell us about your database table??What's the difference between the orginal Db and the db in the floppy??Maybe the db in the floppy is accessXP??...

A question.. I have had problems with Access Databases in the past... sometimes when I copy them to a new location, the permissions don't follow them. Have you made sure that the permissions on your Access DB are set so that everyone can execute against it?

Fisherman,when U copy a ms access file to another directory,the copy operation can't be allowed by operation system??Waht's the message by OS providered??

microsoft jet 3.51 works a lot better for access 2000 mdb files, you could try selecting that as a driver... it worked for me tho...
(original mdb as win3.11 stuff, edited with access 2k, then used jet 3.51 instead of 4.0 and it worked)

No CP, there's no problem inherent in transferring the file. I've just had problems in the past where I've copied the file to a new location, and the copied file no longer has the necessary permissions to execute against it, though the original does.

I checked and the orginal db I have on the floppy is made with accessXP. When I open the db with access2000 and make some changes to it, my program won't work. But if I just copy the db from the floppy to my hard drive the program works fine.

I also tried it with my other computer and accessXP, and the same thing. I think it's weird that a db made with accessXP won't open after I changed it with accessXP.

Any ideas what's going on?

Unkie,
I also tried changing to jet 3.51 and it didn't help => unrecognized format

Any ideas anyone?

Knappe,if u will modify the db file on the floppy when the floppy is protected from writen,it won't work correctly..U should check the floppy..

I have copied the db to my hard drive and I'm using it from there. I haven't done any changes to the db on the floppy, only to the db on my hard drive.

I upgraded my Access from 2000 to XP and it is still not working. Once again: Everything works fine if I just copy the db from the floppy to my hard drive. But if I try to add something to the db the program won't work after that. The db I'm using is made with Access XP.

Could someone please tell me in detail what to do? Which preferences do I need and do I have to change some settings in Access...?

If my friend who gives me the latest databases changes something in the db and gives it to me everything works fine. He uses Access XP. Anyone got any ideas?