What is the latest version of access

I want to buy the latest version of ms access.
Will this version let me create an mdb that will work with a lesser version
such as 2000, I am having a problem going from 2002 to 2000. The mde will
not work.

Is there a place you recommend that has it for a decent price?

Thanks

re: What is the latest version of access

Latest version = 2003.

It works with files in the 2000 format, but will have the same issue, i.e.
can only create MDE with the 2002/2003 format.

You can search around for a price in the country where you live.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Danny" <dannywork5@hotmail.com> wrote in message
news:eDGfc.68930$467.15301644@news4.srv.hcvlny.cv. net...[color=blue]
> I want to buy the latest version of ms access.
> Will this version let me create an mdb that will work with a lesser[/color]
version[color=blue]
> such as 2000, I am having a problem going from 2002 to 2000. The mde will
> not work.
>
> Is there a place you recommend that has it for a decent price?
>
> Thanks[/color]

re: What is the latest version of access

Will a 2003 format run on somebodys pc who has 2000 format?
Can you save an mde from 2003 that will work in a ms 2000 format?


"Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message
news:407f4cd1$0$16581$5a62ac22@freenews.iinet.net. au...[color=blue]
> Latest version = 2003.
>
> It works with files in the 2000 format, but will have the same issue, i.e.
> can only create MDE with the 2002/2003 format.
>
> You can search around for a price in the country where you live.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Danny" <dannywork5@hotmail.com> wrote in message
> news:eDGfc.68930$467.15301644@news4.srv.hcvlny.cv. net...[color=green]
> > I want to buy the latest version of ms access.
> > Will this version let me create an mdb that will work with a lesser[/color]
> version[color=green]
> > such as 2000, I am having a problem going from 2002 to 2000. The mde[/color][/color]
will[color=blue][color=green]
> > not work.
> >
> > Is there a place you recommend that has it for a decent price?
> >
> > Thanks[/color]
>
>[/color]

re: What is the latest version of access

"Danny" <dannywork5@hotmail.com> wrote in message
news:GvJfc.571$rV4.326215@news4.srv.hcvlny.cv.net. ..[color=blue]
> Will a 2003 format run on somebodys pc who has 2000 format?[/color]

No. must use the 2000 format to do that.
[color=blue]
> Can you save an mde from 2003 that will work in a ms 2000 format?[/color]
No A2003 cannot create an MDE that will work on a computer using A2000.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

re: What is the latest version of access

Thanks
I just want to make sure I have what I need. Is there an advantage to
getting access 2003?
So perhaps I will buy 2003, 2000 to cover all bases.
oh, what about 2002?
Thanks

"Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message
news:407f7777$0$16580$5a62ac22@freenews.iinet.net. au...[color=blue]
> "Danny" <dannywork5@hotmail.com> wrote in message
> news:GvJfc.571$rV4.326215@news4.srv.hcvlny.cv.net. ..[color=green]
> > Will a 2003 format run on somebodys pc who has 2000 format?[/color]
>
> No. must use the 2000 format to do that.
>[color=green]
> > Can you save an mde from 2003 that will work in a ms 2000 format?[/color]
> No A2003 cannot create an MDE that will work on a computer using A2000.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
>[/color]

re: What is the latest version of access

2002 and 2003 use the same file format.
You can create a 2002/2003 MDE with either version.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Danny" <dannywork5@hotmail.com> wrote in message
news:eHPfc.12638$rV4.1323846@news4.srv.hcvlny.cv.n et...[color=blue]
> Thanks
> I just want to make sure I have what I need. Is there an advantage to
> getting access 2003?
> So perhaps I will buy 2003, 2000 to cover all bases.
> oh, what about 2002?
> Thanks
>
> "Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message
> news:407f7777$0$16580$5a62ac22@freenews.iinet.net. au...[color=green]
> > "Danny" <dannywork5@hotmail.com> wrote in message
> > news:GvJfc.571$rV4.326215@news4.srv.hcvlny.cv.net. ..[color=darkred]
> > > Will a 2003 format run on somebodys pc who has 2000 format?[/color]
> >
> > No. must use the 2000 format to do that.
> >[color=darkred]
> > > Can you save an mde from 2003 that will work in a ms 2000 format?[/color]
> > No A2003 cannot create an MDE that will work on a computer using A2000.[/color][/color]

re: What is the latest version of access

Dear Danny,

If you are going to develop for Access 2000, it's best for you to
develop IN Access 2000. Whatever advantages Access 2003/2002 may have
will not be worth the hasle of later "downgrading" your database. If
you are going to develop for users of more than one version of access,
it's always best to use the lowest (oldest) version for developing.
This is because any version of Access can always work with DBs
developed with an earlier version, without you needing to do anything.
Using a new version to develop for older versions will always be a
problem.

If you want to take advantage of the newer versions of Access but your
clients don't want to invest in up-to-date software (i.e. Access
2003), YOU can always invest and get Microsoft Office for Developers.
It's a complete version of Office, with all kinds of extras for
developers. The tool you need is called the Packaging and Deployment
Wizard. It creates an installation program (that you may distribute
freely) that includes a Run-Time version of Access plus whatever other
files your application may need (it figures out what your application
needs automaticaly). This, in addition to looking very professional,
means your clients don't need any version of access at all.

I own the 2002 version and the Packaging Wizard works great on WinXP
but gave me some problems on Win98. They may have fixed that on the
2003 version.

Hope this helps...
Noam Nelke, Israel.

PS Try looking for software online (ebay, etc.)

re: What is the latest version of access

I recieved this e-mail:
[color=blue]
> Hi, Noam -
> I caught this post and have a further question:
> With a run-time version can the user add/edit records even though they do
> not have Access on their machine?
>
> Thanks!
>
> Andi Plotsky[/color]

Well, the answer is Yes. The run-time version of Access allowes the
user to do everything except EDITING forms, tables, querys, code and
so on. Editing records IS pemitted. Adding records, deleting records
and so on are all possible. Even edditing tables and forms from code
are possible.

Basicaly the run time version is just like access, only you can't
DEVELOP on it.

If anyone has further questions, please put them on the newsgroup so
that everyone can benefit.

Peace,

Noam Nelke, Israel.