|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Unrecognized database format 'C:\Program Files\Microsoft Office\OFI recently set up the user-level security for my database and have had no
problems opening or working in the database. Prior to setting up the security, my users had no problems opening or working in the database either. Since the security changes, my users are unable to open the database, including one user who is set up as an admin. When they click on the shortcut, the following message appears Unrecognized database format 'C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE. The database is available on a shared drive....why is it looking at my local hard drive? Also, when I open the database, it shows me that I'm opening the file on the shared drive, so I don't understand why it's referencing my local drive. Can someone help me resolve this? What is in the full target of the shortcut? There's more than the path to
msaccess.exe there. Unrecognized database format usually comes up when trying to open for example a 2002 format database in 2000. Perhaps the other user has an earlier version? -- Show quoteHide quoteJoan Wild Microsoft Access MVP "LaVerna" wrote: > I recently set up the user-level security for my database and have had no > problems opening or working in the database. Prior to setting up the > security, my users had no problems opening or working in the database either. > Since the security changes, my users are unable to open the database, > including one user who is set up as an admin. When they click on the > shortcut, the following message appears Unrecognized database format > 'C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE. The database is > available on a shared drive....why is it looking at my local hard drive? > Also, when I open the database, it shows me that I'm opening the file on the > shared drive, so I don't understand why it's referencing my local drive. Can > someone help me resolve this? The full target of the shortcut is "C:\Program Files\Microsoft
Office\OFFICE11\MSACCESS.EXE" "G:\Finance Arcom\MBO's\FY06\Commissions3.mdb" /WRKGRP "G:\Finance Arcom\MBO's\FY06\Security.mdw". All users have the same version as me. Show quoteHide quote "Joan Wild" wrote: > What is in the full target of the shortcut? There's more than the path to > msaccess.exe there. > > Unrecognized database format usually comes up when trying to open for > example a 2002 format database in 2000. Perhaps the other user has an > earlier version? > -- > Joan Wild > Microsoft Access MVP > > > "LaVerna" wrote: > > > I recently set up the user-level security for my database and have had no > > problems opening or working in the database. Prior to setting up the > > security, my users had no problems opening or working in the database either. > > Since the security changes, my users are unable to open the database, > > including one user who is set up as an admin. When they click on the > > shortcut, the following message appears Unrecognized database format > > 'C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE. The database is > > available on a shared drive....why is it looking at my local hard drive? > > Also, when I open the database, it shows me that I'm opening the file on the > > shared drive, so I don't understand why it's referencing my local drive. Can > > someone help me resolve this? OK, so it isn't referencing your hard drive, it's referencing G: drive. If
you mean the path to msaccess.exe, well that would refer to their C: not your's. Anyway, double check that all users have msaccess.exe installed in the same location and also does everyone have G: mapped the same? You could use UNC pathnames instead \\servername\share\something.mdb Also you should split the mdb - put the backend (tables/relationships only) on the server and give each user a copy of the frontend (all other objects and linked tables to the BE) on their PC. Then the shortcut target would be changed to reflect the path to the FE on their C: drive. -- Show quoteHide quoteJoan Wild Microsoft Access MVP "LaVerna" wrote: > The full target of the shortcut is "C:\Program Files\Microsoft > Office\OFFICE11\MSACCESS.EXE" "G:\Finance Arcom\MBO's\FY06\Commissions3.mdb" > /WRKGRP "G:\Finance Arcom\MBO's\FY06\Security.mdw". > > All users have the same version as me. > > > > "Joan Wild" wrote: > > > What is in the full target of the shortcut? There's more than the path to > > msaccess.exe there. > > > > Unrecognized database format usually comes up when trying to open for > > example a 2002 format database in 2000. Perhaps the other user has an > > earlier version? > > -- > > Joan Wild > > Microsoft Access MVP > > > > > > "LaVerna" wrote: > > > > > I recently set up the user-level security for my database and have had no > > > problems opening or working in the database. Prior to setting up the > > > security, my users had no problems opening or working in the database either. > > > Since the security changes, my users are unable to open the database, > > > including one user who is set up as an admin. When they click on the > > > shortcut, the following message appears Unrecognized database format > > > 'C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE. The database is > > > available on a shared drive....why is it looking at my local hard drive? > > > Also, when I open the database, it shows me that I'm opening the file on the > > > shared drive, so I don't understand why it's referencing my local drive. Can > > > someone help me resolve this? 
Other interesting topics
Secured Database works exactly right on one computer, but on another not quite r
More security questions Getting started with security Frontend Downloads Access 2003 on wondows XP de-secure problem The database has been placed in a state... Is it any way to programmatically store and hide data inside an Access database that it is not shown Mystery security group setting changes. add tick boxes inside table Read only report |
|||||||||||||||||||||||
