Re: Office 2007 Service Pack 1

Well, it appears the problem user does have Office 2007 SP1 installed.
Does anyone know of any reason why he would get the "database is in an
unrecognized format" message when he's using the same version of
Access??

On Feb 22, 6:55 pm, "Allen Browne" <AllenBro...@xxxxxxxxxxxxxx> wrote:
The 6211 would be a lower number.

(You don't want to test for an exact number, or your code will fail once SP2
is released.)

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

"evenlater" <evanca...@xxxxxxxxx> wrote in message

news:b57cd453-1b6c-4e0f-a67a-ae1d9d4cbf7c@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Thanks, that's very helpful. But the table in your article only lists
one version # for Access 2007: SP-1, 12.0.6211.1000.
What would the version number be if my user had AK27 installed without
Service Pack 1?

On Feb 20, 9:06 pm, "Allen Browne" <AllenBro...@xxxxxxxxxxxxxx> wrote:

In the interface, go to:
Office Button | Access Options | Resources
The last entry contains SP1 if it has the service pack.

Or, you can examine the version of the msaccess.exe file. The current
service pack for each version of msaccess is listed here:
http://allenbrowne.com/ser-53.html#MSAccess

That page also has a link for getting the version programmatcially:
http://allenbrowne.com/ser-53code.html#GetAccessVersion
(In your case, that's not much use, 'coz the code won't run.)

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

"evenlater" <evanca...@xxxxxxxxx> wrote in message

news:2c424188-4ce3-43b3-b3a6-1cb7d74d18e1@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

My clients have Office 2007 Enterprise Edition. When they try to open
an ACCDE copy of my Access 2007 database, they often get a message
saying "this database is in an unrecognized format."

I understand this occurs when an ACCDE file created on a computer with
Office 2007 Service Pack 1 is opened on a computer without SP1
installed.

How can I find out whether a particular computer has SP1 installed or
not?

Thanks.

.

Relevant Pages

  • Re: Office 2007 Service Pack 1
    ... The last entry contains SP1 if it has the service pack. ... an ACCDE copy of my Access 2007 database, ... I understand this occurs when an ACCDE file created on a computer with ... Office 2007 Service Pack 1 is opened on a computer without SP1 ...
    (comp.databases.ms-access)
  • Re: Applying SP on SQL Cluster (active/passive) after new nodes Ad
    ... Senior Database Administrator ... Microsoft SQL Server MVP ... service pack is running. ... > us either since many of the app IDs are db_owner in their database. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Windows update shows no new update, but I dont have service pack
    ... SP1 Help and Support: ... Disable any software firewall and anti-virus permanently, as SP1 requires a reboot or two before completing. ... If for any reasons you have problems using the Windows Update download, there is a standalone SP1 download available here: Download details: Windows Vista Service Pack 1 Five Language Standalone: ...
    (microsoft.public.windowsupdate)
  • RE: SSIS Transfer object failure
    ... The problem is the "CopySchema" option it has to be set to ... a SQL Server 2005 SP1 database table to another database; ... I would like to let you know that though SQL Server ... 2005 SP1 has fixed many known issues, there are still some new discovered ...
    (microsoft.public.sqlserver.dts)
  • Re: Applying SBS SP1 at this late date
    ... Downloading and Installing Windows Small Business Server 2003 Service Pack 1 ... The SBS 2003 sp1 standard edition including the following components: ...
    (microsoft.public.windows.server.sbs)