473,587 Members | 2,579 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

2007 won't open older format database

Hi,
Last week one client had errors caused by another program which led
the IT guys to wipe out and rebuild the hard drive on one particular
computer. Prior to this happening, the people in this department were
using a 2000 format database through Access 2007 without any issues.
Since IT rebuilt said hard drive, one user now gets a message when
attempting to open the same database that 2007 cannot open older
format databases. The database is secured. Other people in the group
are still logging into the database using 2007 without any issues. I
did see that she got instructions on setting up a trusted location and
she has done so. I am just not sure what could possibly be causing
this. I did do a compact and repair on the database using someone
else's computer while I was in their area, but it didn't change any
thing.
Any ideas as to what I should start looking for?
Thanks,
MM
Sep 22 '08 #1
12 6016
That's not the actual error message. Access 2007 can't open Access 95 and 97
mdes but it can open all other earlier format dbs. Tell her when opening
secure dbs to use a shortcut with a target using this format (all one line):

"path to msaccess.exe" "path to db.mdb" /wrkgrp "path to secure.mdw"

Chris
Microsoft MVP
godiva wrote:
>one user now gets a message when
attempting to open the same database that 2007 cannot open older
format databases. The database is secured.
--
Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200809/1

Sep 22 '08 #2
She is using a properly coded short cut. That was the first thing I
checked. Someone on another computer uses the same short cut and gets
in without a hitch. Is there something in options that I should look
into in Access 2007? Even if I connect to their server and use the
same short cut, I get in using Access 2007. I am concerned that
something was screwed up when they re-installed Access 2007 on her
box.

Chris O'C via AccessMonster.c om wrote:
That's not the actual error message. Access 2007 can't open Access 95 and 97
mdes but it can open all other earlier format dbs. Tell her when opening
secure dbs to use a shortcut with a target using this format (all one line):

"path to msaccess.exe" "path to db.mdb" /wrkgrp "path to secure.mdw"

Chris
Microsoft MVP
godiva wrote:
one user now gets a message when
attempting to open the same database that 2007 cannot open older
format databases. The database is secured.

--
Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200809/1
Sep 22 '08 #3
Unless she's the owner of the db, or a member of the Admins group, or a
member of another custom group with Administrator permissions, she's pretty
limited to what she can do in Access 2007 regarding settings and options.
The only things a normal user can do within Access 2007 with a secure db is
check which workgroup she's permanently joined to, or change workgroups
(which is overridden by using that shortcut with the secure workgroup command
line switch), or check which workgroup she's joined to for the current
session, or change permissions/names/designs on any objects she owns in the
db. She can't give herself permission to open/run the db or remove that
permission if the db is secure.

Find out what the actual error message is when she tries to open the db. It
*can't* be the error message she gave you unless you've made a mistake and
it's really an Access 95 or 97 mde. I don't think that's the case. Access
2007 can open *every* Access db format except those 2, unless it's secured,
and you say she's joined to the correct workgroup with that shortcut, so that
avoids the "You don't have permission to open the dbname.mdb database.
Please see your administrator.. ." error message.

Chris
Microsoft MVP
godiva wrote:
>Is there something in options that I should look
into in Access 2007? Even if I connect to their server and use the
same short cut, I get in using Access 2007. I am concerned that
something was screwed up when they re-installed Access 2007 on her
box.
--
Message posted via http://www.accessmonster.com

Sep 22 '08 #4
On Sep 22, 2:21*pm, "Chris O'C via AccessMonster.c om" <u29189@uwe>
wrote:
Unless she's the owner of the db, or a member of the Admins group, or a
member of another custom group with Administrator permissions, she's pretty
limited to what she can do in Access 2007 regarding settings and options.
The only things a normal user can do within Access 2007 with a secure db is
check which workgroup she's permanently joined to, or change workgroups
(which is overridden by using that shortcut with the secure workgroup command
line switch), or check which workgroup she's joined to for the current
session, or change permissions/names/designs on any objects she owns in the
db. *She can't give herself permission to open/run the db or remove that
permission if the db is secure.

Find out what the actual error message is when she tries to open the db. *It
*can't* be the error message she gave you unless you've made a mistake and
it's really an Access 95 or 97 mde. *I don't think that's the case. *Access
2007 can open *every* Access db format except those 2, unless it's secured,
and you say she's joined to the correct workgroup with that shortcut, so that
avoids the "You don't have permission to open the dbname.mdb database.
Please see your administrator.. ." error message.

Chris
Microsoft MVP

godiva wrote:
Is there something in options that I should look
into in Access 2007? *Even if I connect to their server and use the
same short cut, I get in using Access 2007. I am concerned that
something was screwed up when they re-installed Access 2007 on her
box.

--
Message posted viahttp://www.accessmonst er.com
Is the workgroup file a central file on a server somewhere or does
each computer get its own copy? If it's on the user's computer, copy
the workgroup file from a computer where the application is working
correctly and try again.

Bruce
Sep 22 '08 #5
The mdw is on the network drive. The database is a 2000 format
database. She does not even get to the login prompt before Access 2007
tells her it can't open the database. yet, I go to another person's
computer with Access 2007 using the same short cut and there are no
issues getting in at all.

Bruce wrote:
On Sep 22, 2:21�pm, "Chris O'C via AccessMonster.c om" <u29189@uwe>
wrote:
Unless she's the owner of the db, or a member of the Admins group, or a
member of another custom group with Administrator permissions, she's pretty
limited to what she can do in Access 2007 regarding settings and options.
The only things a normal user can do within Access 2007 with a secure db is
check which workgroup she's permanently joined to, or change workgroups
(which is overridden by using that shortcut with the secure workgroup command
line switch), or check which workgroup she's joined to for the current
session, or change permissions/names/designs on any objects she owns inthe
db. �She can't give herself permission to open/run the db or remove that
permission if the db is secure.

Find out what the actual error message is when she tries to open the db.. �It
*can't* be the error message she gave you unless you've made a mistake and
it's really an Access 95 or 97 mde. �I don't think that's the case. �Access
2007 can open *every* Access db format except those 2, unless it's secured,
and you say she's joined to the correct workgroup with that shortcut, so that
avoids the "You don't have permission to open the dbname.mdb database.
Please see your administrator.. ." error message.

Chris
Microsoft MVP

godiva wrote:
>Is there something in options that I should look
>into in Access 2007? �Even if I connect to their server and use the
>same short cut, I get in using Access 2007. I am concerned that
>something was screwed up when they re-installed Access 2007 on her
>box.
--
Message posted viahttp://www.accessmonst er.com

Is the workgroup file a central file on a server somewhere or does
each computer get its own copy? If it's on the user's computer, copy
the workgroup file from a computer where the application is working
correctly and try again.

Bruce
Sep 23 '08 #6
It's hard to troubleshoot the problem when she won't tell you the exact error
message. Is she getting this error message when she tries to open the db
file in Access 2007?

"This database is in an unrecognized format. The database may have been
created with a later version of Microsoft Office Access than the one you are
using. Upgrade your version of Microsoft Office Access to the current one,
then open this database."

Chris
Microsoft MVP
godiva wrote:
>The mdw is on the network drive. The database is a 2000 format
database. She does not even get to the login prompt before Access 2007
tells her it can't open the database. yet, I go to another person's
computer with Access 2007 using the same short cut and there are no
issues getting in at all.
--
Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200809/1

Sep 23 '08 #7
Don't assume that she isn't telling me about the error message. I
have been to her desk and got the error myself that mentioned that it
can't open that format and suggested doing a compact/repair. I'm
planning on going to her desk to reinstall Office 2007 to see if that
might get it over it's issues especially since she was opening the
database with 2007 prior to them wiping her hard drive and
reinstalling software.

Chris O'C via AccessMonster.c om wrote:
It's hard to troubleshoot the problem when she won't tell you the exact error
message. Is she getting this error message when she tries to open the db
file in Access 2007?

"This database is in an unrecognized format. The database may have been
created with a later version of Microsoft Office Access than the one you are
using. Upgrade your version of Microsoft Office Access to the current one,
then open this database."

Chris
Microsoft MVP
godiva wrote:
The mdw is on the network drive. The database is a 2000 format
database. She does not even get to the login prompt before Access 2007
tells her it can't open the database. yet, I go to another person's
computer with Access 2007 using the same short cut and there are no
issues getting in at all.

--
Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200809/1
Sep 23 '08 #8
godiva wrote:
Don't assume that she isn't telling me about the error message. I
have been to her desk and got the error myself that mentioned that it
can't open that format and suggested doing a compact/repair. I'm
planning on going to her desk to reinstall Office 2007 to see if that
might get it over it's issues especially since she was opening the
database with 2007 prior to them wiping her hard drive and
reinstalling software.
Does the user have a full version of Access or runtime? If full, can
you create a new (temp) database and link to the tables from her
machine? Can you create a dummy back end and attempt to link to the
dummy from the temp?

>
Chris O'C via AccessMonster.c om wrote:
>>It's hard to troubleshoot the problem when she won't tell you the exact error
message. Is she getting this error message when she tries to open the db
file in Access 2007?

"This database is in an unrecognized format. The database may have been
created with a later version of Microsoft Office Access than the one you are
using. Upgrade your version of Microsoft Office Access to the current one,
then open this database."

Chris
Microsoft MVP
godiva wrote:
>>>The mdw is on the network drive. The database is a 2000 format
database. She does not even get to the login prompt before Access 2007
tells her it can't open the database. yet, I go to another person's
computer with Access 2007 using the same short cut and there are no
issues getting in at all.

--
Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200809/1
Sep 23 '08 #9
When you do, please write down the exact error message - verbatim - and post
it here. It's not likely that reinstalling Office 2007 is going to resolve
the issue unless you take the correct additional steps - which you may be
able to do right now without reinstalling Office 2007.

Chris
Microsoft MVP
godiva wrote:
>Don't assume that she isn't telling me about the error message. I
have been to her desk and got the error myself that mentioned that it
can't open that format and suggested doing a compact/repair. I'm
planning on going to her desk to reinstall Office 2007 to see if that
might get it over it's issues especially since she was opening the
database with 2007 prior to them wiping her hard drive and
reinstalling software.
--
Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200809/1

Sep 23 '08 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

27
45525
by: Wayne | last post by:
I've been clicking around Access 2007 Beta 2 and can't see the custom menu bar designer. Is it in the beta? Maybe I'm blind. The question that comes to mind is: Will custom menu bars be the same height as they were in previous versions or will they be the "ribbon" style that takes up a huge portion of the screen? Also when I use Access...
49
4328
by: Allen Browne | last post by:
If you are looking for opinon on what's useful in Access 2007, there's a new article at: http://allenbrowne.com/Access2007.html Covers what's good (useful features), what's mixed (good and bad), what's gone (features removed), what's fixed (old issues solved), what's broken (new bugs), configuration, compatibility, should you buy, and...
4
8554
by: mrouleau | last post by:
I am sorry if this is the wrong group to ask, if so please point me in the correct direction. My problem is I have an MDB file with user-level security on it (mdw). When i move it over to a system that has Access 2007 and try to open it, I get a user name and password prompt. The admin username and password from the other system doesn't...
17
7657
by: Neil | last post by:
A client of mine likes some of the new bells and whistles in Access 2007, and is thinking about converting our A03 format MDB to an A07 format file. However, while some of the users have A07, many do not, and it's not clear when they would get it. His thought was to use the upcoming Access 2007 runtime to allow the users who are still running...
16
11055
by: Neil | last post by:
I posted a few days ago that it seems to me that the Access 2007 rich text feature does not support: a) full text justification; b) programmatic manipulation. I was hoping that someone might know one way or the other whether that was true or not, or could point me to an article or help text that would. What I have seen so far online and in...
0
3734
by: ppardi | last post by:
I'm developing an addin for Word 2007 and I need to determine whether a user saves a Word 2007 document in an older format (97-2003) after a save as is done. The scenario is that the user starts out with a Word 2007 document, saves that document to disk, then saves the same document in an older format If the user saves a doc in an older...
5
8990
by: ISUTri | last post by:
We are currently converting from Access 2003 to Access 2007. I have an Access app that is going to be very difficult to convert. This App is used by people that are out in the field and are a long distance from where our Access Databases are. So that is why we have Replication set up. So they have a local copy that they can replicate to...
4
2525
by: jonathan184 | last post by:
Hi I have a perl script, basically what it is suppose to do is check a folder with files. Now the files are checked using a timestamp with the command ls -l so the timestamp in this format is checked. Now what the script does is it checks the time stamp and creates a year folder if it does not exist and then creates a month folder if it does not...
14
9429
by: Brian Nelson | last post by:
Sorry for the long post, I've tried so hard to solve this one but I'm just stuck! We've had a multiuser .mdb file on a network share for years. I know it's not ideal, but it's worked well from Access 2000 to 2003. Ever since we upgraded to 2007, we've noticed some serious bloating. When we were on 2003, after a fresh compact, the database...
0
7843
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8206
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7967
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
8220
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5713
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupr who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5392
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3840
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3875
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1185
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.