Upgrading Access to 2007

[Bobby]

Hi,
I have an application which is written in Access 2003, with a SQL
server 2000 back end. The application uses a lot of VBA, as well as
quite a few macros.

We are about to upgrade to Office 2007. What are the main issues I
should look out for?

Thanks for any help

Colin

[Allen Browne]

Re: Upgrading Access to 2007

Here's a starting point:

http://allenbrowne.com/Access2007.html

The article doesn't deal specificially with the SQL Server back end: that
depends if it's MDB or ADP.

--
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.

"Bobby" <bobby2@blueyon der.co.ukwrote in message
news:d262aab8-b34e-4a41-a3fe-bd31ea0a0bca@28 g2000hsw.google groups.com...

Hi,
I have an application which is written in Access 2003, with a SQL
server 2000 back end. The application uses a lot of VBA, as well as
quite a few macros.
>
We are about to upgrade to Office 2007. What are the main issues I
should look out for?
>
Thanks for any help
>
Colin

[DFS]

Re: Upgrading Access to 2007

Allen Browne wrote:

Here's a starting point:

http://allenbrowne.com/Access2007.html

>
The article doesn't deal specificially with the SQL Server back end:
that depends if it's MDB or ADP.

Thanks for putting that together. It will save me some time and headaches
if any clients move to 2007.

[oli-s@comcast.net]

Re: Upgrading Access to 2007

On Feb 16, 10:58 am, "DFS" <nospam@dfs_.co mwrote:

Allen Browne wrote:

Here's a starting point:
http://allenbrowne.com/Access2007.html

>

The article doesn't deal specificially with the SQL Server back end:
that depends if it's MDB or ADP.

>
Thanks for putting that together. It will save me some time and headaches
if any clients move to 2007.

Hi,
you might also find my website helpful. It deals with the conversion
process from Acc2003 to 2007:

http://www.access-freak.com

HTH
Good luck

[DFS]

Re: Upgrading Access to 2007

oli-s@comcast.net wrote:

On Feb 16, 10:58 am, "DFS" <nospam@dfs_.co mwrote:

>Allen Browne wrote:

>>Here's a starting point:
>> http://allenbrowne.com/Access2007.html

>>

>>The article doesn't deal specificially with the SQL Server back end:
>>that depends if it's MDB or ADP.

>>
>Thanks for putting that together. It will save me some time and
>headaches if any clients move to 2007.

>
Hi,
you might also find my website helpful. It deals with the conversion
process from Acc2003 to 2007:
>

http://www.access-freak.com

>
HTH
Good luck

Awesome, oli-s! I glanced at it just now, but I'll read the whole thing in
the next couple days.

[Bobby]

Re: Upgrading Access to 2007

On 16 Feb, 09:14, "Allen Browne" <AllenBro...@Se eSig.Invalidwro te:

Here's a starting point:
   http://allenbrowne.com/Access2007.html
>
The article doesn't deal specificially with the SQL Server back end: that
depends if it's MDB or ADP.
>
--
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.
>
"Bobby" <bob...@blueyon der.co.ukwrote in message
>
news:d262aab8-b34e-4a41-a3fe-bd31ea0a0bca@28 g2000hsw.google groups.com...
>
>
>

Hi,
I have an application which is written in Access 2003, with a SQL
server 2000 back end. The application uses a lot of VBA, as well as
quite a few macros.

>

We are about to upgrade to Office 2007. What are the main issues I
should look out for?

>

Thanks for any help

>

Colin- Hide quoted text -

>
- Show quoted text -

Thanks a lot. Sorry I took so long to get back,

Colin