What MS Access version to use?

Hi,

I would like to use MS Access as database for my application. Program will
be made in VS 2005. What MS Access version is best to use, 2003, 2002, 2000?
What version do you reccomend?

Thanks very much,
Tomislav

If you're going to be using VS 2005 to build the application, you're not
really using Access, you're using a Jet database.

All three of the versions of Access you list use the same version of Jet,
4.0, so it doesn't really matter.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Tomislav" wrote in message
...
Hi,

I would like to use MS Access as database for my application. Program will
be made in VS 2005. What MS Access version is best to use, 2003, 2002,
2000?
What version do you reccomend?

Thanks very much,
Tomislav

If you are using VS2005 have you considered using SQLS2005 - they are
designed to work together.

If you download an Express Version of VS2005 (VB, VC++, VC#, Java or Web
Developer) you will get SQL Server 2005 Express thrown in.

SQL Server 2005 Express is also available as a standalone download.

As already explained you are not using Access if you are only using a
Database containing just tables and relationships, this is actually Jet.

The current version is Jet 4.0 (SP8).

--
Slainte

Craig Alexander Morrison
Crawbridge Data (Scotland) Limited

"Tomislav" wrote in message
...
Hi,

I would like to use MS Access as database for my application. Program will
be made in VS 2005. What MS Access version is best to use, 2003, 2002,
2000?
What version do you reccomend?

Thanks very much,
Tomislav

Thanks Craig,

If you are using VS2005 have you considered using SQLS2005 - they are
designed to work together.

I don't know how difficult is to install/deploy application with SQL 2005
Express, and what operating systems are supported with SQL 2005 Express. I
would like that my app works also under Windows 98 (although this is old
operating system, but still some users have it), Windows 2000, Windows XP
Home and Proffesional.

Thanks very much,
Tomislav


"Craig Alexander Morrison" wrote in
message ...

If you download an Express Version of VS2005 (VB, VC++, VC#, Java or Web
Developer) you will get SQL Server 2005 Express thrown in.

SQL Server 2005 Express is also available as a standalone download.

As already explained you are not using Access if you are only using a
Database containing just tables and relationships, this is actually Jet.

The current version is Jet 4.0 (SP8).

--
Slainte

Craig Alexander Morrison
Crawbridge Data (Scotland) Limited

"Tomislav" wrote in message
...
Hi,

I would like to use MS Access as database for my application. Program
will
be made in VS 2005. What MS Access version is best to use, 2003, 2002,
2000?
What version do you reccomend?

Thanks very much,
Tomislav

Apparently SQLS 2005 requires Windows 2000 SP4 or later ...

http://www.microsoft.com/downloads/d...displaylang=en

Of course, your client app could still run on Windows 98 if the Windows 98
PC can connect to a suitable server.

--
Brendan Reynolds
Access MVP

"Tomislav" wrote in message
...
Thanks Craig,

If you are using VS2005 have you considered using SQLS2005 - they are
designed to work together.

I don't know how difficult is to install/deploy application with SQL 2005
Express, and what operating systems are supported with SQL 2005 Express. I
would like that my app works also under Windows 98 (although this is old
operating system, but still some users have it), Windows 2000, Windows XP
Home and Proffesional.

Thanks very much,
Tomislav


"Craig Alexander Morrison" wrote in
message ...

If you download an Express Version of VS2005 (VB, VC++, VC#, Java or Web
Developer) you will get SQL Server 2005 Express thrown in.

SQL Server 2005 Express is also available as a standalone download.

As already explained you are not using Access if you are only using a
Database containing just tables and relationships, this is actually Jet.

The current version is Jet 4.0 (SP8).

--
Slainte

Craig Alexander Morrison
Crawbridge Data (Scotland) Limited

"Tomislav" wrote in message
...
Hi,

I would like to use MS Access as database for my application. Program
will
be made in VS 2005. What MS Access version is best to use, 2003, 2002,
2000?
What version do you reccomend?

Thanks very much,
Tomislav

Thanks,

dont use MDB for anything
use SQL express or MSDE

Do you have real reasons why not using MS Access (JET 4.0)?. Consider this
is rather small application, and my goal is that application deploys easily,
and that I dont have to install SP2 on Windows XP or SP4 on Windows 2000.

Thanks very much,
Tomislav

"Tomislav" wrote:

dont use MDB for anything
use SQL express or MSDE

Do you have real reasons why not using MS Access (JET 4.0)?. Consider this
is rather small application, and my goal is that application deploys easily,
and that I dont have to install SP2 on Windows XP or SP4 on Windows 2000.

I can't see the person to whom you are replying but I suspect it's an
Aaron Kempf. If so he has a real problem with the MDB format for
reasons which are blindingly obvious to himself. Unfortunately, in
most cases, the reasons don't make sense to others.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

I thought you'd agreed to stop slagging off at MDBs.

TC [MVP Access]

The .NET Framework 2.0 requires Windows 2000 to be updated to at least SP3,
and Windows XP to be updated to SP2 ...

http://www.microsoft.com/downloads/d...d-aab15c5e04f5

.... so if you're targeting that version of the framework, you'll need to
deal with the SP issue anyway. I don't know whether VS 2005 allows you to
create apps that target an earlier version of the framework?

--
Brendan Reynolds
Access MVP

"Tomislav" wrote in message
...
Thanks,

dont use MDB for anything
use SQL express or MSDE

Do you have real reasons why not using MS Access (JET 4.0)?. Consider this
is rather small application, and my goal is that application deploys
easily, and that I dont have to install SP2 on Windows XP or SP4 on
Windows 2000.

Thanks very much,
Tomislav

Which does not take * A N Y * time, because the code only relinks
them when they have * M O V E D * , and the previous links * N O
L O N G E R W O R K * .

See if you can understand this, Aaaron. You really don't need to be
Albert Einstein.

TC [MVP Access]