Access 2003 and 2007

[Jac Tremblay]

Hi,
On my computer, I have the two versions of Access, 2003 and 2007. I want to
keep the 2003 version for testing my Access 2007 applications.
The problem:
When I double click an Access application icon, Access 2003 starts instead
of Access 2007 that I want. If I create a shortcut on the desktop, the same
thing happens. Windows installer starts and it takes time.
How can I make the 2007 Access version the default?
Thanks.

 

[Douglas J. Steele]

Hi,
On my computer, I have the two versions of Access, 2003 and 2007. I want
to
keep the 2003 version for testing my Access 2007 applications.
The problem:
When I double click an Access application icon, Access 2003 starts instead
of Access 2007 that I want. If I create a shortcut on the desktop, the
same
thing happens. Windows installer starts and it takes time.
How can I make the 2007 Access version the default?

You can't. The default will always be the most recently used version of
Access.

Change your shortcut so that it includes the full path to whichever version
of Access it is you want to use for that particular database:

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
"C:\Folder\Database.mdb"

 

[Jac Tremblay]

Hi Douglas,
---
You can't. The default will always be the most recently used version of
Access.
---
That's not what's happening with my system. It defaults to Access 2003 and I
always use Access 2007.
Of course, I can change the shortcut path, but it a pain to have to do it
every time I create a database or a shortcut. I thought there was some trick.
I guess not
Thanks anyway.

 

[AccessVandal via AccessMonster.com]

Hi,

If you're using XP, not sure about Vista. Go to Control Panel - Folder
Options - File Types Tab In the Registered file types list box, select the
file extention of 'MDB' and below, click the 'Change' button. Select the
Application listed or click the 'Browse' button to search the Access version
you to open by default.

Hi Douglas,
---
You can't. The default will always be the most recently used version of
Access.
---
That's not what's happening with my system. It defaults to Access 2003 and I
always use Access 2007.
Of course, I can change the shortcut path, but it a pain to have to do it
every time I create a database or a shortcut. I thought there was some trick.
I guess not
Thanks anyway.
[quoted text clipped - 15 lines]

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
"C:\Folder\Database.mdb"

 

[AccessVandal via AccessMonster.com]

Edit :

or click the 'Browse' button to search the Access version
you want to open by default.

 

[Jac Tremblay]

Hi AccessVandal,
That is a good trick. It helps but I'm not sure I will do it for now for
there are certain issues concerning clients that have Access 2000, 2002 or
2003.
Thanks for your time. I will keep your advice in mind for the future.
--
Jac Tremblay

Hi,

If you're using XP, not sure about Vista. Go to Control Panel - Folder
Options - File Types Tab In the Registered file types list box, select the
file extention of 'MDB' and below, click the 'Change' button. Select the
Application listed or click the 'Browse' button to search the Access version
you to open by default.

Hi Douglas,
---
You can't. The default will always be the most recently used version of
Access.
---
That's not what's happening with my system. It defaults to Access 2003 and I
always use Access 2007.
Of course, I can change the shortcut path, but it a pain to have to do it
every time I create a database or a shortcut. I thought there was some trick.
I guess not
Thanks anyway.

Hi,
On my computer, I have the two versions of Access, 2003 and 2007. I want

[quoted text clipped - 15 lines]

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
"C:\Folder\Database.mdb"