Can Access 2003 read and modify mdb files created by Access 2007

[Guest]

I have a MDB database file created under Access 2003 and is being used by
several people over a Local network.

One of the user has upgraded to Office 2007 and the remaining people stays
with Access 2003.

Can that Access 2007 user convert the A03 MDB files into an A07 MDB files
and this new MDB be accessable and be modified by other users with A03.

Thanks!

Brian

 

[Tony Toews [MVP]]

I have a MDB database file created under Access 2003 and is being used by
several people over a Local network.

One of the user has upgraded to Office 2007 and the remaining people stays
with Access 2003.

Can that Access 2007 user convert the A03 MDB files into an A07 MDB files

Yes. Although the new extension is ACCDB

and this new MDB be accessable and be modified by other users with A03.

No.

But why have the A2007 user even convert the A2003 MDBs to A2007
format? A2007 can execute A2000, A2002 and A2003 MDBs just fine.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Guest]

The problem we have with this is every time the A03 file is opened by the A07
user it asks them to update the database. They fuddle-finger the dialogue box
and hit the wrong button and upgrade it.
What I would like to do is turn on that dialog box asking them to upgrade
the file. We could do that with a group policy change in A03, but can't find
a similar setting in A07

 

[Guest]

I meant to say:

What I would like to do is turn OFF the dialog box asking them to upgrade
the file.

 

[Guest]

Hi, Tony,

It does not make sense if MS does not allow A00 - 03 to read or modify *.mdb
files which has been modified by A07.

All other Office 07 programs such as Excel or Words allowed previous
versions to read and modify files created by Office 07 if they are saved in
their format.

So you mean Microsoft is trying to give AC users a hard time if they don't
upgrade to A07.

I don't get this.

Brian

 

[Douglas J. Steele]

Access has a long history of Version n-1 not being able to open files
created in Version n. In fact, Access 2002 and Access 2003 were the only
versions that didn't force the user to use a new file format.

 

[David W. Fenton]

Access has a long history of Version n-1 not being able to open
files created in Version n. In fact, Access 2002 and Access 2003
were the only versions that didn't force the user to use a new
file format.

And A2K was the first that could save in the previous version, as
well.

 

[Guest]

I think we are all carried away by the new features and the capabilities of
Office 2007.

Access 2000 and Access 2003, like all other previous Office versions, can
read and modify MDB files created or modified by Access 2007.

I have done a test on the LAN in my office. All users, whther A03 or A07,
can share, read and modify MDB files without a problem so long if we change
the default security setting for Office 2007.


Brian

 

[David W. Fenton]

Access 2000 and Access 2003, like all other previous Office
versions, can read and modify MDB files created or modified by
Access 2007.

I have done a test on the LAN in my office. All users, whther A03
or A07, can share, read and modify MDB files without a problem so
long if we change the default security setting for Office 2007.

They can't read or modify an ACCDB file.

Which was the point of the question.

Of *course* they can read an MDB created in A2K3 or A2K2 or A2K
format. The only thing that is relevant is the *new* format, and the
older versions of Access cannot open and read them.