Re: MDW

Of course you can convert to 2000 and leave it at that since 2003 reads 2000.
Cuts the conversion time in half!

Klatuu wrote:
Good for you. Here are a couple of excerpts from Documentation our research
people put together:

Database Version Access 2003 Compatibility
Access 97 If you are currently using a version of Access that is older than
Access 2000, you must convert your files to Access 2000 before working with
them in Access 2003.
Access 2000 Access 2003 supports the Access 2000 file format? so, in most
cases, you need only install Access 2003 and then open your Access 2000
files, even if they contain VBA code. However, if your database employs data
access pages and they were created using Access 2000, you will have to
convert them.
Access 2003 Access 2003 supports the Access 2002-2003 file formats, so in
most cases you need only install Access 2003 and open your Access 2002 files.
Access 2003 also uses the Microsoft Office XP Web Components to create data
access pages. Because the same components were used to create data access
pages in Access 2002, those pages will work normally in Access 2003.

2.2.1. Identify any special steps / procedures necessary to open Access 97 /
2000 / 2002 MDB files in workgroup mode. Are there restrictions placed on
the MDB when opened in Access 2003 (can?t update design, modules that need
recoding)? If one person has a file open are there any conversions / updates
made to the MDB that would prevent someone from Access 97 / 2000 / 2002 from
using the MDB at the same time.
Access 2003 does not fully support the Access 97 file format. Access 97
files will have to be converted or enabled before working with them in Access
2003. When Access 2003 enables the database, the original database format is
maintained. When you use an enabled Access database in Access 2003, you can
view database objects and add, delete, or modify records in Access 2003, but
you can't modify the design of objects. To modify the design of existing
objects or to add new objects, you must open the file in the previous version
of Access. Microsoft has detailed instructions for converting Access 97
files including workgroup information files - see the Access 2003 Help
documentation for more information. No special steps / procedures or
restrictions were found to open a 2000 / 2002 MDB file in workgroup mode.

Multi-User Databases are databases which have an associated WIF (Workgroup
Information File). Multi-User databases typically will have a host of issues
that could complicate the conversion process.
? Access Restriction: Only a user with Admin authority as defined within
the WIF(.mdw) will be able to convert the associated mdb file (AND) the
database will have to be opened exclusively which will lock out all other
users until the database was converted.
? WIF (Workgroup Information File) The WIF contains the database
permissions: the groups and users as well as their relative level of
authority for each part of the database. It is not required that the WIF
(mdw) be converted at the same time as the associated mdb, however it is
recommended by Microsoft to convert the WIF(mdw) to take advantage of new
security features contained with 2003. Warning: If the WIF was built upon the
SYSTEM.MDW rather than creating a new WIF, when the Access97 installation is
removed it may remove the SYSTEM.MDW as well. This could result, depending on
the circumstances, in a total inability to recover the data from the
database. A copy of the WIF should be made and it?s associated groups, users
and permissions printed in order to prevent this scenario from occurring.

I don't know if this will have any impact on your specific problem, but in
the research I have done, it is recommend you do not convert directly from
[quoted text clipped - 8 lines]
Regards,
Keith.

--
Message posted via http://www.accessmonster.com
.

Relevant Pages

  • Web Developers - Happy Hearts And HDTV! - Lockergnome
    ... Certificate on your MSIIS Web server. ... getting data from a database is only half the problem. ... Zend recently started a series about building rock solid code in PHP. ... which provides bulk database conversion. ...
    (freebsd-questions)
  • Re: Converting database from Access 97 to 2003: problems
    ... Although the owner of the database had all the rights the conversion was not ... placed the Admin user in the Admins group (Admins group has Administrator ...
    (microsoft.public.access.conversion)
  • Re: MDW
    ... If one person has a file open are there any conversions / updates ... using the MDB at the same time. ... When Access 2003 enables the database, ... Multi-User Databases are databases which have an associated WIF (Workgroup ...
    (microsoft.public.access.gettingstarted)
  • Re: How To Rebuild Objects From Text Files?
    ... Error 2205 (Database Name) can't create the output file. ... I converted the Access 2000 mdb to Access 2003 ... a better strategy for conversion than using Access' menu tool, ... I then tried importing some of the forms ...
    (comp.databases.ms-access)
  • RE: Conversion from VT_DECIMAL TO VT_I8 failed
    ... Welcome to MSDN newsgroup. ... Regarding on the Type Converting problem met in accessing database through ... Conversion from VT_DECIMAL TO VT_I8 failed ...
    (microsoft.public.data.oledb)