Prev: DoCmd.RunCommand acCmdSaveRecord
Next: Turkısh
From: Doug on 17 May 2010 13:23
When I try to saving as a mdb to the 2007 accdb I get an error message. The
message indicates that the database is opened to a user. That user is the
message is my own computer. How do I stop this and be able to convert a 2003
routine or mdb to a accdb?
From: Arvin Meyer [MVP] on 17 May 2010 14:31
"Doug" <Doug(a)discussions.microsoft.com> wrote in message
news:5C52A73D-3A84-4C3F-B50F-AF024B7EC0D4(a)microsoft.com...
> When I try to saving as a mdb to the 2007 accdb I get an error message.
> The
> message indicates that the database is opened to a user. That user is the
> message is my own computer. How do I stop this and be able to convert a
> 2003
> routine or mdb to a accdb?

First, unless you need the new features available only in the ACCDB format,
you should leave your file as an MDB. That way it can be used by everyone,
and is considerably smaller in size.

If you must use the new format, first make sure that the MDB will compile,
then try closing it. Make sure there is no LDB file left, or delete it if
there is. Now convert the file.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


 | 
Pages: 1
Prev: DoCmd.RunCommand acCmdSaveRecord
Next: Turkısh