Posted question converting .mdb to .accdb more info

[DMC]

I posted the previous question on converting a .mdb database to a 2007
database. The database I use is set up for teaching with tables for classes
taught and students attending. The database was created in 2002 and has lots
of info in it. I needed a field in the classes table to show the students
attending the paticular class. I added the field using lookup wizard linked
to the studentdents database. The field when used in classes shows all
students in the student table but I can only chose one. I know that assess
2007 allows you to chose multiple this is why I want to convert. The student
table is also linked to a word template to be able to print completion
certificates.

When trying to convert or save as a 2007 database I get an error message
stating-
You attempted to open a database that is already opened exclusively by user
<admin> on machine <mypc>. Try again when the database is available. (Error
3356).
This PC is a family PC and I am the admistrator. I have tried everythig I
know to fix the problem short of creating a new database. Please help.
Thanks DMC

 

[Arvin Meyer [MVP]]

I posted the previous question on converting a .mdb database to a 2007
database. The database I use is set up for teaching with tables for
classes
taught and students attending. The database was created in 2002 and has
lots
of info in it. I needed a field in the classes table to show the students
attending the paticular class. I added the field using lookup wizard
linked
to the studentdents database. The field when used in classes shows all
students in the student table but I can only chose one. I know that
assess
2007 allows you to chose multiple this is why I want to convert. The
student
table is also linked to a word template to be able to print completion
certificates.

When trying to convert or save as a 2007 database I get an error message
stating-
You attempted to open a database that is already opened exclusively by
user
<admin> on machine <mypc>. Try again when the database is available.
(Error
3356).
This PC is a family PC and I am the admistrator. I have tried everythig I
know to fix the problem short of creating a new database. Please help.
Thanks DMC

First, you do not have to convert to the new format to use your database.
MDBs work fine in 2007, and I prefer them because they are backward
compatible.

That said, if you still want to convert to the new format, try creating a
new empty database and importing the objects from the earlier one.

 

[John W. Vinson]

I posted the previous question on converting a .mdb database to a 2007
database. The database I use is set up for teaching with tables for classes
taught and students attending. The database was created in 2002 and has lots
of info in it. I needed a field in the classes table to show the students
attending the paticular class. I added the field using lookup wizard linked
to the studentdents database. The field when used in classes shows all
students in the student table but I can only chose one. I know that assess
2007 allows you to chose multiple this is why I want to convert.

Just because Microsoft made a dreadfully bad decision to allow non-normalized
multivalue fields, doesn't mean you need to go along with their mistake.

You can enroll multiple students in a class in Access 2002 (or Access 1.0 if
you have a copy sitting around): you just need a *third table*, Enrollment
let's say, with a field for StudentID and ClassID. You can enter as many
students as you wish into a class (or assign a student to as many classes as
they are taking) using a Subform; you can also add fields to Enrollment to
store information about *this* student in *this* class, such as date enrolled,
final grade, etc.