Access 97 - 2000 conversion privileges - why don't I get an option

  • Thread starter Thread starter Troygon
  • Start date Start date
T

Troygon

I maintain a shared Access 97 database. There is an accompanying mdw
file containing logonids passwords and access rights. A copy of the
database tables is copied daily to a separate server so as to give
others read-only access to the data. Generally this has worked OK for
the past 8 years.

Recently, when people on Access 2000 try to access this read-only copy
they get a message telling them they aren't members of our workgroup
and so don't have the privileges to convert the database. While this
is true I certainly don't want them to be able to convert the
database as those on 97 then wouldn't be able to read it. What I
don't understand is why they don't get a message asking them if
they want to convert - they would then reply "no" and their lack
of privileges wouldn't matter.

What am I missing here? Can anyone advise me?
 
Recently, when people on Access 2000 try to access this read-only copy
they get a message telling them they aren't members of our workgroup
and so don't have the privileges to convert the database.
Click to expand...

I don't know if "workgroup" is ambiguous here.

Are the Access 2000 users using the same MDW file as the Access 97 users? If
not, for the Access 2000 users, you have a choice between making the MDW
file their default workgroup file using the Workgroup Administrator program
or creating a shortcut to start the database that includes the workgroup as
a command line switch, eg:

"C:\Program Files\Microsoft Office\Office\msaccess.exe" "C:\MyDatabase.mdb"
/wrkgrp "C:\MyWorkgroup.mdw"

If that's not it, then I'm afraid I don't know.

Regards
Geoff
 
A 97 file has to be modified to be opened in 2000 or newer. It does not have to
be "converted", but there is still a small change made. This used to be
described as "enabling" it. That change cannot be done on a read only file or
MDE which is why 97 MDEs cannot be opened in the newer versions.

You might be able to "enable" the file by turning off the read only flag and
opening it once in 2000, then setting the read only flag back on afterwards.
 
Geoff said:
I don't know if "workgroup" is ambiguous here.

Are the Access 2000 users using the same MDW file as the Access 97 users? If
not, for the Access 2000 users, you have a choice between making the MDW
file their default workgroup file using the Workgroup Administrator program
or creating a shortcut to start the database that includes the workgroup as
a command line switch, eg:

"C:\Program Files\Microsoft Office\Office\msaccess.exe" "C:\MyDatabase.mdb"
/wrkgrp "C:\MyWorkgroup.mdw"

If that's not it, then I'm afraid I don't know.

Regards
Geoff
Click to expand...


Geoff,

Thanks for taking the time and trouble to reply. No, these other users
are remote users and don't have access to our MDW file. They will
probably be using the default MDW file on their hard drive. I could try
sending them our MDW file with a shortcut but there are some practical
difficulties I need to get around first.

Regards, Roy
 
Rick said:
A 97 file has to be modified to be opened in 2000 or newer. It does not have to
be "converted", but there is still a small change made. This used to be
described as "enabling" it. That change cannot be done on a read only file or
MDE which is why 97 MDEs cannot be opened in the newer versions.

You might be able to "enable" the file by turning off the read only flag and
opening it once in 2000, then setting the read only flag back on afterwards.
Click to expand...


Rick,

Thanks for taking the time and trouble to reply. It sounds like I need
to get a 2000 version of MS Access to do some further testing on this.

Regards,

Roy
 
Back
Top