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]

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" <bo****@blueyonder.co.ukwrote in message
news:d2**********************************@28g2000h sw.googlegroups.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]

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]

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

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]

ol***@comcast.net wrote:

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

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

On 16 Feb, 09:14, "Allen Browne" <[e-mail]:

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" <[e-mail] in message

news:d2**********************************@28g2000h sw.googlegroups.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