OPENING ACCESS 2007 DATABASE IN ACCESS 2003

T

Tom

I have a database created in access 2007 and want to open and allow changes
on a computer that has Office 2003. This way my original database will remain
in tact.

I know Microsoft has a program to do this for Excel and Word--Does any one
know of one for Access?

Unreated question the Office 2007 only allows download to 2 legal licenses?
I have a desktop and 2 laptops. When buying, I thought you were allowed 3
licenses?
 
P

Pete D.

You can convert the 2007 down to older versions but any new features of 2007
will have to be stripped out before converting it back or you will get a
message that will prevent conversion due to incompatable features. See save
as. Best to always develope in oldest version expected to use. At least
that is what the experts here usually say, it is rare I have to go backwards
and then usually just my backend data.
 
B

boblarson

You could use the free Access Runtime to use the Access 2007 files (in the
new format).
--
Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP

Tutorials at http://www.btabdevelopment.com

__________________________________
 
T

Tom Wickerath

The Access runtime is a free download, for the first time with Access 2007.
For all prior versions, developers had to purchase the appropriate software
from Microsoft first, in order to distribute the runtime. Basically, you can
install Access in a crippled mode on any Windows-based PC. The runtime allows
one to open the file, add / edit / delete data, print reports, etc. However,
they do not have any design capabilities, so they cannot make changes to
forms and reports.

For more information, please see Access MVP Tony Toews' page that covers
this in detail:

Microsoft Access (Office) Developer Edition Versions
http://www.granite.ab.ca/access/developereditionversions.htm

Please be aware that if the other PC already has a copy of Access installed,
and you then install the runtime, that user will experience some delay
whenever they switch from using their full version to the runtime, as stuff
gets re-registered. It can take a couple of minutes each time.

You can simulate the runtime environment on your PC, by starting Access with
the optional /runtime switch. Click on Start | Run, and enter:

msaccess "CompletePathToYourFile" /runtime

You will need to provide some type of startup switchboard form, or a custom
ribbon, in the runtime environment.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
L

Larry Linson

Tom said:
<SNIP>
Unreated question the Office 2007 only allows download
to 2 legal licenses? I have a desktop and 2 laptops. When
buying, I thought you were allowed 3 licenses?
Click to expand...

Once they added the "included license" for a mobile installation (e.g.,
laptop), as far as I can remember, it has always been one license for the
fixed installation and another for the mobile installation, for a total of
two. But, to get your information from "an authoritative source", visit
http://office.microsoft.com and search.

Larry Linson
Microsoft Office Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Share Access database between Access 2007 & 2003 1
Opening Access Database from Internet Explorer 2
Access 2003/2007 compatibility 8
Cannot edit shared access database in 2007? 3
How do you connect Word 2003 to Access 2007 accdb database??? 3
ACCESS 2007 in ACCESS 2003 1
Access 2003 - 2007 4
trying to run access 2003 database in access 2007 8

Top