Visual Basic&database, VB6/Access 97 app on computer running Access 2000

VB6/Access 97 app on computer running Access 2000

Author	Message
boofymart #1 / 4	VB6/Access 97 app on computer running Access 2000 I've written an application using VB6 connecting to an Access 97 database. I've used the Package & Deployment Wizard to create an installation CD. Most of the users are running Access 97 (or nothing). However some users at a different site are apparently running Access 2000. My question is, if I give the installation CD to the Access 2000 users, will they be able to install and run my program even though they have Access 2000 installed? Will the VB6 program still work with the Access 97 database, alongside a full installation of Access 2000? What sort of issues do I face with this? I don't want to break their Access 2000 installation, but I also would prefer not to build a separate Access 2000 version, especially as I don't even have a copy of Access 2000. Any advice would be greatly appreciated. Stuart Allen
Sun, 07 Mar 2004 07:51:23 GMT

Norm Yua #2 / 4	VB6/Access 97 app on computer running Access 2000 It depends upon how do you use Access in your Application and how the VB program accesses to the Access database, through ADO or DAO? If your application has set a reference to Access 8.0 object library (Access97), obviously, your application will not work. If you only use Access as back-end database, then thing will depend upon how do you access to it. the ADO, or DAO libray, or Jet engine version is different, and may co-exist on the same computer, due to the way they are installed. if one of these libraries referenced in your program is not found in the computer, the program will likely crash. The safest way may be use DNS to access dabase. In your program, use DNS in database ConnectionString to access database. As long as you can create the DNS on the client computer, no matter what verion of lirary installed, your application should be working. Keep in mind, most software is backward compatible, that is Access2K can open Access97 .mdb file but Access 97 cannot open Access2K.mdb file. Quote: > I've written an application using VB6 connecting to an Access 97 > database. I've used the Package & Deployment Wizard to create an > installation CD. Most of the users are running Access 97 (or nothing). > However some users at a different site are apparently running Access > 2000. > My question is, if I give the installation CD to the Access 2000 > users, will they be able to install and run my program even though > they have Access 2000 installed? Will the VB6 program still work with > the Access 97 database, alongside a full installation of Access 2000? > What sort of issues do I face with this? I don't want to break their > Access 2000 installation, but I also would prefer not to build a > separate Access 2000 version, especially as I don't even have a copy > of Access 2000. > Any advice would be greatly appreciated. > Stuart Allen
Mon, 08 Mar 2004 00:25:15 GMT

Rogbak #3 / 4	VB6/Access 97 app on computer running Access 2000 If your VB just needs to see/change tables in the database, it should not matter that the version of your .mdb may be an older version of Access that the person using your program has. However, if you actually need to have your VB program open Access (to run a macro, show a report, run a query..etc) then on the user's computer, it will attempt to open an Access 97 database using Access 2000. A prompt on their display would ask them if they would want to convert the database to a 2000 version. If they elected not to, it might ask this every time. If they did convert it, yourself (the developer) would not be able to go back into the database if you needed to check something for them. -Roger Quote: > I've written an application using VB6 connecting to an Access 97 > database. I've used the Package & Deployment Wizard to create an > installation CD. Most of the users are running Access 97 (or nothing). > However some users at a different site are apparently running Access > 2000. > My question is, if I give the installation CD to the Access 2000 > users, will they be able to install and run my program even though > they have Access 2000 installed? Will the VB6 program still work with > the Access 97 database, alongside a full installation of Access 2000? > What sort of issues do I face with this? I don't want to break their > Access 2000 installation, but I also would prefer not to build a > separate Access 2000 version, especially as I don't even have a copy > of Access 2000. > Any advice would be greatly appreciated. > Stuart Allen
Tue, 09 Mar 2004 00:03:49 GMT

boofymart #4 / 4	VB6/Access 97 app on computer running Access 2000 Quote: > If your VB just needs to see/change tables in the database, it should > not matter that the version of your .mdb may be an older version of > Access that the person using your program has. However, if you > actually need to have your VB program open Access (to run a macro, > show a report, run a query..etc) then on the user's computer, it will > attempt to open an Access 97 database using Access 2000. A prompt on > their display would ask them if they would want to convert the > database to a 2000 version. If they elected not to, it might ask this > every time. If they did convert it, yourself (the developer) would not > be able to go back into the database if you needed to check something > for them. > -Roger Thanks Roger, you've eased my mind somewhat. The VB app only uses the Access database as a data source, it doesn't need to get at forms etc. I was hoping that would be the case, as I expected the setup package would include whatever files are necessary to get at the data, regardless of what version of Access (if any) is installed on the target machine. Thanks again, Stuart
Tue, 09 Mar 2004 07:26:47 GMT

Page 1 of 1

[ 4 post ]