I am presently using Access 2003 and contemplating upgrading to 2007 and have 
a couple of questions.

1-If I keep my MDB as "2002-2003 format" can it take advantage of all the 
changes, in particuler "Export to PDF", I want to be able to Email directly 
(no more PrimoPDF)?

2-If I change my MDB to 2007 can I still replicate to the others MDB's 
("2002-2003 format")?

Thanks for any help.

On Mon, 8 Mar 2010 15:24:01 -0800, Wind54Surfer
<Wind54Surfer@discussions.microsoft.com> wrote:

There is no A2007 MDB format. However you can continue to use your
2002/2003 format MDBs in A2007 just fine. If you need to use
replication, that would be your best choice.

-Tom.
Microsoft Access MVP


>I am presently using Access 2003 and contemplating upgrading to 2007 and have 
>a couple of questions.
>
>1-If I keep my MDB as "2002-2003 format" can it take advantage of all the 
>changes, in particuler "Export to PDF", I want to be able to Email directly 
>(no more PrimoPDF)?
>
>2-If I change my MDB to 2007 can I still replicate to the others MDB's 
>("2002-2003 format")?
>
>Thanks for any help.

Thanks for your response, but can you elaborate a little bit more, if I keep 
the 2002/2003 format, can I take advantage of the new features of 2007?

"Tom van Stiphout" wrote:

> On Mon, 8 Mar 2010 15:24:01 -0800, Wind54Surfer
> <Wind54Surfer@discussions.microsoft.com> wrote:
> 
> There is no A2007 MDB format. However you can continue to use your
> 2002/2003 format MDBs in A2007 just fine. If you need to use
> replication, that would be your best choice.
> 
> -Tom.
> Microsoft Access MVP
> 
> 
> >I am presently using Access 2003 and contemplating upgrading to 2007 and have 
> >a couple of questions.
> >
> >1-If I keep my MDB as "2002-2003 format" can it take advantage of all the 
> >changes, in particuler "Export to PDF", I want to be able to Email directly 
> >(no more PrimoPDF)?
> >
> >2-If I change my MDB to 2007 can I still replicate to the others MDB's 
> >("2002-2003 format")?
> >
> >Thanks for any help.
> .
> 

On Tue, 9 Mar 2010 15:44:01 -0800, Wind54Surfer
<Wind54Surfer@discussions.microsoft.com> wrote:

Which features are you thinking of?
Generally: no.

-Tom.
Microsoft Access MVP


>Thanks for your response, but can you elaborate a little bit more, if I keep 
>the 2002/2003 format, can I take advantage of the new features of 2007?
>
>"Tom van Stiphout" wrote:
>
>> On Mon, 8 Mar 2010 15:24:01 -0800, Wind54Surfer
>> <Wind54Surfer@discussions.microsoft.com> wrote:
>> 
>> There is no A2007 MDB format. However you can continue to use your
>> 2002/2003 format MDBs in A2007 just fine. If you need to use
>> replication, that would be your best choice.
>> 
>> -Tom.
>> Microsoft Access MVP
>> 
>> 
>> >I am presently using Access 2003 and contemplating upgrading to 2007 and have 
>> >a couple of questions.
>> >
>> >1-If I keep my MDB as "2002-2003 format" can it take advantage of all the 
>> >changes, in particuler "Export to PDF", I want to be able to Email directly 
>> >(no more PrimoPDF)?
>> >
>> >2-If I change my MDB to 2007 can I still replicate to the others MDB's 
>> >("2002-2003 format")?
>> >
>> >Thanks for any help.
>> .
>> 

If you want to replicate, and you want the latest features-- then you
should use 'Access Data Projects'

the backend is SQL Server, and that's what most people use for
replication these days.

Im sad that they dropped replication from Access 2007 (format) I used
to use it in a WAN environment back in 2000, and it was so worthless,
I just replaced it with a whole bunch of append / update queries

(you know you can still do that, right?)



On Mar 9, 6:13=A0pm, Tom van Stiphout <tom7744.no.s...@cox.net> wrote:
> On Tue, 9 Mar 2010 15:44:01 -0800, Wind54Surfer
>
> <Wind54Sur...@discussions.microsoft.com> wrote:
>
> Which features are you thinking of?
> Generally: no.
>
> -Tom.
> Microsoft Access MVP
>
> >Thanks for your response, but can you elaborate a little bit more, if I =
keep
> >the 2002/2003 format, can I take advantage of the new features of 2007?
>
> >"Tom van Stiphout" wrote:
>
> >> On Mon, 8 Mar 2010 15:24:01 -0800, Wind54Surfer
> >> <Wind54Sur...@discussions.microsoft.com> wrote:
>
> >> There is no A2007 MDB format. However you can continue to use your
> >> 2002/2003 format MDBs in A2007 just fine. If you need to use
> >> replication, that would be your best choice.
>
> >> -Tom.
> >> Microsoft Access MVP
>
> >> >I am presently using Access 2003 and contemplating upgrading to 2007 =
and have
> >> >a couple of questions.
>
> >> >1-If I keep my MDB as "2002-2003 format" can it take advantage of all=
 the
> >> >changes, in particuler "Export to PDF", I want to be able to Email di=
rectly
> >> >(no more PrimoPDF)?
>
> >> >2-If I change my MDB to 2007 can I still replicate to the others MDB'=
s
> >> >("2002-2003 format")?
>
> >> >Thanks for any help.
> >> .

"a a r o n . k e m p f @ g m a i l . c o m" <aaron.kempf@gmail.com>
wrote in
news:edcc6bef-bf34-4311-b049-6ac72f3a011e@o16g2000prh.googlegroups.co
m: 

> If you want to replicate, and you want the latest features-- then
> you should use 'Access Data Projects'
> 
> the backend is SQL Server, and that's what most people use for
> replication these days.

Define "most people."

Another idiotic answer from Aaron, of course.

-- 
David W. Fenton                  http://www.dfenton.com/ 
usenet at dfenton dot com    http://www.dfenton.com/DFA/

most people prefer sql server to jet

that's a fact

just because you hang out with a bunch of jet crybabies doesn't mean
that most companies, most developers- prefer SQL to jet





On Mar 10, 11:51=A0am, "David W. Fenton" <XXXuse...@dfenton.com.invalid>
wrote:
> "a a r o n . k e m p f @ g m a i l . c o m" <aaron.ke...@gmail.com>
> wrote innews:edcc6bef-bf34-4311-b049-6ac72f3a011e@o16g2000prh.googlegroup=
s.co
> m:
>
> > If you want to replicate, and you want the latest features-- then
> > you should use 'Access Data Projects'
>
> > the backend is SQL Server, and that's what most people use for
> > replication these days.
>
> Define "most people."
>
> Another idiotic answer from Aaron, of course.
>
> --
> David W. Fenton =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0http://www.dfenton.com=
/
> usenet at dfenton dot com =A0 =A0http://www.dfenton.com/DFA/

Aaron.

You claim to be a database developer, yet the statements you make would 
cause even a new-comer to the profession squirm with embarrassment. Surely, 
you realize that there is no room for ambiguous generalizations like "most 
people" in any sort of technical discussion. In our profession, there is no 
room for "most", or "a lot". We are responsible for delivering ACCURATE, 
REPEATABLE results every single time.

Surely you understand that if you were to deliver a database that returned 
valid results "most of the time" your customer would be entitled to fire you 
on the spot. So, please, if you MUST continue to offer wild assertions and 
irresponsible claims, at least spare yourself the embarrassment doing so in 
vague generalities. Let's see some statistical substantiation here, 
including the methodology you used to obtain your results. Until then, it is 
just plain impossible to take you seriously.



"a a r o n . k e m p f @ g m a i l . c o m" <aaron.kempf@gmail.com> wrote in 
message 
news:0faddf10-17a1-461e-9a28-5837f392435d@t34g2000prm.googlegroups.com...
> most people prefer sql server to jet
>
> that's a fact
>
> just because you hang out with a bunch of jet crybabies doesn't mean
> that most companies, most developers- prefer SQL to jet
>
>
>
>
>
> On Mar 10, 11:51 am, "David W. Fenton" <XXXuse...@dfenton.com.invalid>
> wrote:
>> "a a r o n . k e m p f @ g m a i l . c o m" <aaron.ke...@gmail.com>
>> wrote 
>> innews:edcc6bef-bf34-4311-b049-6ac72f3a011e@o16g2000prh.googlegroups.co
>> m:
>>
>> > If you want to replicate, and you want the latest features-- then
>> > you should use 'Access Data Projects'
>>
>> > the backend is SQL Server, and that's what most people use for
>> > replication these days.
>>
>> Define "most people."
>>
>> Another idiotic answer from Aaron, of course.
>>
>> --
>> David W. Fenton                  http://www.dfenton.com/
>> usenet at dfenton dot com    http://www.dfenton.com/DFA/
> 

"Wind54Surfer" <Wind54Surfer@discussions.microsoft.com> wrote in message 
news:AF50E225-3821-43E4-990B-ACBA0F10A1B9@microsoft.com...
>I am presently using Access 2003 and contemplating upgrading to 2007 and 
>have
> a couple of questions.
>
> 1-If I keep my MDB as "2002-2003 format" can it take advantage of all the
> changes, in particuler "Export to PDF", I want to be able to Email 
> directly
> (no more PrimoPDF)?
>
> 2-If I change my MDB to 2007 can I still replicate to the others MDB's
> ("2002-2003 format")?
>
> Thanks for any help. 

listen to the FACTS

jet doesn't work over wireless

the majority of machines sold today are laptops / netbooks / portables

case in point- jet is obsolete.

furthermore, it doesn't truly support X64- or multi-core processors
(the majority of CPUs sold today are BOTH)





On Mar 12, 8:12=A0pm, "GP George" <george_hepwo...@hotmail.com> wrote:
> Aaron.
>
> You claim to be a database developer, yet the statements you make would
> cause even a new-comer to the profession squirm with embarrassment. Surel=
y,
> you realize that there is no room for ambiguous generalizations like "mos=
t
> people" in any sort of technical discussion. In our profession, there is =
no
> room for "most", or "a lot". We are responsible for delivering ACCURATE,
> REPEATABLE results every single time.
>
> Surely you understand that if you were to deliver a database that returne=
d
> valid results "most of the time" your customer would be entitled to fire =
you
> on the spot. So, please, if you MUST continue to offer wild assertions an=
d
> irresponsible claims, at least spare yourself the embarrassment doing so =
in
> vague generalities. Let's see some statistical substantiation here,
> including the methodology you used to obtain your results. Until then, it=
 is
> just plain impossible to take you seriously.
>
> "a a r o n . k e m p f @ g m a i l . c o m" <aaron.ke...@gmail.com> wrote=
 in
> messagenews:0faddf10-17a1-461e-9a28-5837f392435d@t34g2000prm.googlegroups=
..com...
>
> > most people prefer sql server to jet
>
> > that's a fact
>
> > just because you hang out with a bunch of jet crybabies doesn't mean
> > that most companies, most developers- prefer SQL to jet
>
> > On Mar 10, 11:51 am, "David W. Fenton" <XXXuse...@dfenton.com.invalid>
> > wrote:
> >> "a a r o n . k e m p f @ g m a i l . c o m" <aaron.ke...@gmail.com>
> >> wrote
> >> innews:edcc6bef-bf34-4311-b049-6ac72f3a011e@o16g2000prh.googlegroups.c=
o
> >> m:
>
> >> > If you want to replicate, and you want the latest features-- then
> >> > you should use 'Access Data Projects'
>
> >> > the backend is SQL Server, and that's what most people use for
> >> > replication these days.
>
> >> Define "most people."
>
> >> Another idiotic answer from Aaron, of course.
>
> >> --
> >> David W. Fenton =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0http://www.dfenton.=
com/
> >> usenet at dfenton dot com =A0 =A0http://www.dfenton.com/DFA/

"a a r o n . k e m p f @ g m a i l . c o m" <aaron.kempf@gmail.com>
wrote in
news:da4ba8a2-1f12-4498-91a0-12075a56b6dd@n7g2000prc.googlegroups.com
: 

[obscenities deleted:]

> wtf are you talking about, stalker?
> 
> wild assertions ?
> 
> jet xxxxxxx xxxxx a xxx xxx xxxxxx xxxx.
> 
> there's nothing wild about that assertions!
> 
> Everyone knows that jet just plain xxxxx.. except the old xxxxxxx
> in this one newsgroup.
> 
> The real world moved to SQL Server a LONG time ago.. or mySQL or
> Oracle.
> 
> jet just doesn't cut it, it doesn't have any benefit over ADP /
> SQL Server
> 
> You don't need to take me seriously, you're a xxxxxx xxxxxxx jet
> xxxxxxx xxxxxx, why should I give a xxxx what some xxxxxxx xxxxxx
> thinks?

15 words that are obscenities/insults out of 93 total (and I'm not
counting WTF, of course): 

> fucking sucks 
> 
> big fat donkey dick
> 
> sucks
> 
> retards 
> 
> mother fucking
> 
> crybaby retard
> 
> fuck 
> 
> crybaby retard

That 16% ratio of obscenities and insults to other text.

Way to go Aaron. This is exactly how one gains the respect of
others, i.e., by making sure that more than 10% of your posts is an
obscenity or an insult. 

-- 
David W. Fenton                  http://www.dfenton.com/ 
usenet at dfenton dot com    http://www.dfenton.com/DFA/

"a a r o n . k e m p f @ g m a i l . c o m" <aaron.kempf@gmail.com>
wrote in
news:73dec295-0de7-49eb-a543-e301c8b2879d@m27g2000prl.googlegroups.co
m: 

> You've spent more on DB software than I have in the past 15 years!

How do you know this?

Unless, of course, you've spent ZERO, which wouldn't surprise me,
since your "knowledge" of SQL Server would suggest that you've never
done anything but read about it. 

-- 
David W. Fenton                  http://www.dfenton.com/ 
usenet at dfenton dot com    http://www.dfenton.com/DFA/

:m!!!nnn

"Wind54Surfer" <Wind54Surfer@discussions.microsoft.com> a écrit dans le 
message de groupe de discussion : 
AF50E225-3821-43E4-990B-ACBA0F10A1B9@microsoft.com...
> I am presently using Access 2003 and contemplating upgrading to 2007 and 
> have
> a couple of questions.
>
> 1-If I keep my MDB as "2002-2003 format" can it take advantage of all the
> changes, in particuler "Export to PDF", I want to be able to Email 
> directly
> (no more PrimoPDF)?
>
> 2-If I change my MDB to 2007 can I still replicate to the others MDB's
> ("2002-2003 format")?
>
> Thanks for any help. 

technically, I Just spend $49 on a copy of SQL Server developers
edition.. I've gotten ~5 copies of this previously for free (from MS)




On Mar 16, 12:25=A0pm, "David W. Fenton" <XXXuse...@dfenton.com.invalid>
wrote:
> "a a r o n . k e m p f @ g m a i l . c o m" <aaron.ke...@gmail.com>
> wrote innews:73dec295-0de7-49eb-a543-e301c8b2879d@m27g2000prl.googlegroup=
s.co
> m:
>
> > You've spent more on DB software than I have in the past 15 years!
>
> How do you know this?
>
> Unless, of course, you've spent ZERO, which wouldn't surprise me,
> since your "knowledge" of SQL Server would suggest that you've never
> done anything but read about it.
>
> --
> David W. Fenton =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0http://www.dfenton.com=
/
> usenet at dfenton dot com =A0 =A0http://www.dfenton.com/DFA/

David;

And I still find it funny when you claim that I don't know about SQL
Server.

I'm a certified DBA.. I make twice as much money as -ANY- jet retard

And I've been writing SQL Server fulltime for 11 years.

Prior to that, I had a couple of solid years with Access / VBA / VB6,
etc

Thanks-- but the facts state that I know my way around SQL Server.

-Aaron



On Mar 16, 12:25=A0pm, "David W. Fenton" <XXXuse...@dfenton.com.invalid>
wrote:
> "a a r o n . k e m p f @ g m a i l . c o m" <aaron.ke...@gmail.com>
> wrote innews:73dec295-0de7-49eb-a543-e301c8b2879d@m27g2000prl.googlegroup=
s.co
> m:
>
> > You've spent more on DB software than I have in the past 15 years!
>
> How do you know this?
>
> Unless, of course, you've spent ZERO, which wouldn't surprise me,
> since your "knowledge" of SQL Server would suggest that you've never
> done anything but read about it.
>
> --
> David W. Fenton =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0http://www.dfenton.com=
/
> usenet at dfenton dot com =A0 =A0http://www.dfenton.com/DFA/

"a a r o n . k e m p f @ g m a i l . c o m" <aaron.kempf@gmail.com>
wrote in
news:2de70f6e-70b6-4c0f-8c33-95bee917f6b6@q15g2000yqj.googlegroups.co
m: 

> And I still find it funny when you claim that I don't know about
> SQL Server.

Your posts demonstrate it, since almost everyone gets something
signficant wrong about whatever topic you address, including SQL
Server. 

> I'm a certified DBA.. I make twice as much money as -ANY- jet
> retard 

Yeah, right.

> And I've been writing SQL Server fulltime for 11 years.

Since the age of 4?

> Prior to that, I had a couple of solid years with Access / VBA /
> VB6, etc
> 
> Thanks-- but the facts state that I know my way around SQL Server.

The evidence that is available to the public, i.e., your public
posts, demonstrates quite plainly that you are almost as ignorant of
SQL Server as you are of Access and Jet/ACE. 

-- 
David W. Fenton                  http://www.dfenton.com/ 
usenet at dfenton dot com    http://www.dfenton.com/DFA/