Saving 2007 Access database as 2003

[Owl]

I am struggling to save a 2007 Access database as a 2003 database. What is
confusing is that you have to be in it otherwise the option is greyed out,
but when it shows the name of the database with the .mdb extension and I
click on Save it gives a message with words to the effect of saying that I am
in the database and the file cannot be saved when I am in it. Somewhere in
the process it said that the file had to be closed and did I want that and I
accepted that but nothing was closed in the process.

Thank you for any help.

 

[Owl]

What I have done is to create a blank .mdb database and import everything and
it worked, but I would still like to know how to save a 2007 database as a
2003 database, please.

 

[Jeff Boyce]

Are you attempting to save as A2003, but using the same name as your A2007
db?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Gina Whipp]

Owl,

If the extension is .MDB it's already a 2003 database (or earlier) so I am
confused what you are trying to do and why.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

What I have done is to create a blank .mdb database and import everything
and
it worked, but I would still like to know how to save a 2007 database as a
2003 database, please.

 

[Owl]

Jeff, yes, except for the extension, but it doesn't have to be.

 

[Owl]

Gina, it was an .accdb file, but during the process of trying to save it as
an .mdb file, it shows the name that it WOULD be (and thus with an extension
of .mdb, if only I could have got it saved, but then it doesn't save it.

 

[Gina Whipp]

Owl,

Then as Jeff's question indicates, what happens if you use a different name?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina, it was an .accdb file, but during the process of trying to save it as
an .mdb file, it shows the name that it WOULD be (and thus with an extension
of .mdb, if only I could have got it saved, but then it doesn't save it.

 

[De Jager]

I am struggling to save a 2007 Access database as a 2003 database. What is
confusing is that you have to be in it otherwise the option is greyed out,
but when it shows the name of the database with the .mdb extension and I
click on Save it gives a message with words to the effect of saying that I
am
in the database and the file cannot be saved when I am in it. Somewhere
in
the process it said that the file had to be closed and did I want that and
I
accepted that but nothing was closed in the process.

Thank you for any help.

 

[joelgeraldine]

jkjkjk

Jeff, yes, except for the extension, but it doesn't have to be.