Connect Access97 to MSDE

04-20-2004, 08:11 PM
hi every1..
i need to connect my Access 97 database to MSDE.. does anyone noe how to do this? i found alot of articles on how to connect access 2000 to MSDE but not access 97 to msde. converting access 97 to 2000 is not an option for me as my application can only use access 97...

04-21-2004, 04:15 AM
Hi i hope that you mean Data Enviroment in VB right?
i tried to connect using it with jet 4.0 and it was ok
did you try to do it or just because you didnt find any articles for that

04-22-2004, 12:16 AM
hi there..
well no.. not data environment.. i m using ado and dao.. i need both cos i haf different components in my project that requires ado and dao.....
thanks for replying :P

04-22-2004, 12:27 AM
hi there.. i left out somthing
i m using jet 4.0 too.. so can i open access 97 and upsize it using access 2000 cos i only haf access2000. i haf to change the connection string too rite? i m getting confused over access database, access project database, msde database.. btw what's the difference between adp and mdf file? which connect to which .. and to which database my vb project connects to?

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum