Do I need Access 2000 and + installed 2

[JFRobishow]

Hi everyone,

I'm currently working on a small application that use a MS Access 2000 database. It's working ok on my box which have MS Access XP installed, OS is WinXP.

Eventualy (when it's ready) it will be deployed on other machine, which are likely to have Win98 on them with at most Access 97 installed (there are possibilities that it wouldn't be)

I'm wondering before I start rolling up some code to handle two different types of database if it's needed?

Will my app. work even if Access isn't installed on the target machine? Will it work if at least Access 97 is installed?

Thanks in advance for your answers/suggestions.

 

[fredericofonseca]

whenever you deploy your application you MUST also deply the Access 2000 RUNTIME.

Search Microsoft for this.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[johnwm]

If you are using the Access 2K as a front end then you will need to install it on all machines. If you are just using the Jet4 database (as used by Access2K) as a backend database accessed via ADO then just include the appropriate MDAC references.

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

 

[JFRobishow]

Hi,

Thanks to both of you for your answers. My applications create the database itself through code. I connect to it using Microsoft Jet OLEDB 4.0 provider, so it's only backend right? sorry english isn't my first language so I wanted to make sure that I had the terms right.

I only do normal operation provided via ADO after I'm connected (create table, drop, update, query, etc)

The users never actually open the database on their machine (in Access), they access it through the application GUI only.

So it should work w/o Access 2000 then, it only need the MDAC reference?

 

[fredericofonseca]

IF you are not using Access forms and code for it then yes only the MDAC.

For what you said I expect you to be using VB + ADO, so you're fine.


I would still try it out, by installing your app on a machine without any access components installed.
e.g. either use something like VMWARE or MS Virtual PC to create a brand new install of Wxx, or install the OS on a new HD.

Install the MDAC (2.7 or 2.8).
Then try your app and see if it works.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[JFRobishow]

Thanks frederic and johnwm for your time and answer. I'll test that soon, I'll just install a fresh Windows 98 on a secondary HD and boot to it.