PC Review


Reply
Thread Tools Rate Thread

Access 2007 convert to access 2003

 
 
=?Utf-8?B?U3Rhbg==?=
Guest
Posts: n/a
 
      28th Mar 2007
I have 2007 database that I wish to save as 2003, so that my colleagues can
use it. I have downloaded the conversion tool. However when I click on the
save as tab on the ribbon, All the formats are greyed out and I can not save
it. If I change the suffix 2003 looks at it but can not open it.
Help please
 
Reply With Quote
 
 
 
 
Allen Browne
Guest
Posts: n/a
 
      28th Mar 2007
1. Go to:
Office Button | Access Options | Populate
and set the Default File Format to Access 2000 format.

2. Create a new database:
Office Button | New
It will be in A2000 format.

3. Open the new database, and import everything.
Click the External Data tab of the ribbon, and the Access icon on the Import
group.

You now have a database that can be opened and manipulated in Access 2000,
2002, 2003, or 2007.

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

"Stan" <(E-Mail Removed)> wrote in message
news:147B7AB4-E5AE-4760-B4CE-(E-Mail Removed)...
>I have 2007 database that I wish to save as 2003, so that my colleagues can
> use it. I have downloaded the conversion tool. However when I click on
> the
> save as tab on the ribbon, All the formats are greyed out and I can not
> save
> it. If I change the suffix 2003 looks at it but can not open it.
> Help please


 
Reply With Quote
 
=?Utf-8?B?TEJD?=
Guest
Posts: n/a
 
      5th Jul 2007
I have developed an application in ver. 2003. A customer want to use this
application in Access 2007. Is it possible that my customer uses it and
frequently returns the database to my and I make corrections in my ver. 2003
and then returns the corrected database to the customer. Briefly: Can you "go
back" in version number?
--
LBC


 
Reply With Quote
 
Paul Shapiro
Guest
Posts: n/a
 
      5th Jul 2007
You don't have to go back in version number. Split the db into 2 databases:
a) a front-end db with all the forms, queries, code and reports, and b) a
backend db with just the tables and all the relationships. Now your customer
owns the backend, with their data. You can replace the frontend with an
updated version, without needing to get the latest data from the client.

If you keep building in Access 2003, it will remain an Access 2003-formatted
database, which your client should be able to use in Access 2007. If there
are some issues, you can probably fix them in your master version of the
front-end db.

"LBC" <(E-Mail Removed)> wrote in message
news:B8BC3BED-6BDC-4129-A02D-(E-Mail Removed)...
>I have developed an application in ver. 2003. A customer want to use this
> application in Access 2007. Is it possible that my customer uses it and
> frequently returns the database to my and I make corrections in my ver.
> 2003
> and then returns the corrected database to the customer. Briefly: Can you
> "go
> back" in version number?



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How To Convert Access 2003 Application To Access 2007 Version EarlCPhillips Microsoft Access VBA Modules 2 8th Mar 2010 10:44 PM
How do i convert access 2007 to 2003 files using access 2003? cw00 Microsoft Access 2 15th Sep 2009 05:19 PM
Convert Access 2003 with security to Access 2007 Roxana Microsoft Access 2 2nd Jun 2009 03:46 PM
can you convert 2007 Access back to 2003 Joyce Microsoft Access 1 16th Jan 2008 02:51 PM
Convert Access 2003 app to 2007, what to expect? sandal Microsoft Access Form Coding 1 22nd May 2007 06:57 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:49 PM.