MS Access Multiuser - "enabling" an mdb from 2000--how?

Author

"enabling" an mdb from 2000--how?

Kevin

2006-01-05, 3:24 am

I have some co-workers with 97, some with 2000, a few with a later
version.

In an article at www.suite101.com/article.cfm/ms_office2000/118644
I saw this (last paragraph), which seemed to be just the ticket for my
situation:

"Rather than convert an earlier version Access database to Access 2000,
you may want simply to enable an Access database. This is especially
useful in a multiuser environment where all users are unable to upgrade
to Microsoft Acccess 2000 at the same time. When a database must be
used simultaneously with different versions of Access, users who have
upgraded to Access 2000 can enable a database in an earlier version
format. When an Access 2000 user enables the database, the original
format is retained so that users of earlier versions of Access can
continue to use the database. For example, if a shared database is
created in Access 95, it can be used with Microsoft Access 95 and
enabled in Access 2000."

How do you "enable"a database. Are there known issues with this
approach?

Sylvain Lafontaine

2006-01-05, 3:24 am

Users of Access 2000 can only edit data of an enabled database but cannot
modify any object (tables, forms, reports).

Another possibility for you would be to split the database. For more info
on these two topics, see:

http://www.microsoft.com/technet/pr...e/acssmgde.mspx

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

"Kevin" <kevind@sonic.net> wrote in message
news:43bca058$0$5809
8$742ec2ed@news.sonic.net...
>I have some co-workers with 97, some with 2000, a few with a later
> version.
>
> In an article at www.suite101.com/article.cfm/ms_office2000/118644
> I saw this (last paragraph), which seemed to be just the ticket for my
> situation:
>
> "Rather than convert an earlier version Access database to Access 2000,
> you may want simply to enable an Access database. This is especially
> useful in a multiuser environment where all users are unable to upgrade
> to Microsoft Acccess 2000 at the same time. When a database must be
> used simultaneously with different versions of Access, users who have
> upgraded to Access 2000 can enable a database in an earlier version
> format. When an Access 2000 user enables the database, the original
> format is retained so that users of earlier versions of Access can
> continue to use the database. For example, if a shared database is
> created in Access 95, it can be used with Microsoft Access 95 and
> enabled in Access 2000."
>
> How do you "enable"a database. Are there known issues with this
> approach?
>

2006-01-05, 7:24 am

When you first open an A97 database in A2K+, you
are given the options of enabling or converting the database.
If you do not choose either option, you are not able to open
the database.

(david)

"Kevin" <kevind@sonic.net> wrote in message
news:43bca058$0$5809
8$742ec2ed@news.sonic.net...
> I have some co-workers with 97, some with 2000, a few with a later
> version.
>
> In an article at www.suite101.com/article.cfm/ms_office2000/118644
> I saw this (last paragraph), which seemed to be just the ticket for my
> situation:
>
> "Rather than convert an earlier version Access database to Access 2000,
> you may want simply to enable an Access database. This is especially
> useful in a multiuser environment where all users are unable to upgrade
> to Microsoft Acccess 2000 at the same time. When a database must be
> used simultaneously with different versions of Access, users who have
> upgraded to Access 2000 can enable a database in an earlier version
> format. When an Access 2000 user enables the database, the original
> format is retained so that users of earlier versions of Access can
> continue to use the database. For example, if a shared database is
> created in Access 95, it can be used with Microsoft Access 95 and
> enabled in Access 2000."
>
> How do you "enable"a database. Are there known issues with this
> approach?
>

Sponsored Links