473,322 Members | 1,352 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

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 6000
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.com
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.com 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.com
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.com" <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.accessmonster.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.com" <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.accessmonster.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.com
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.com 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.com
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.com 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.com
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.com
http://www.accessmonster.com/Uwe/For...ccess/200809/1

Sep 23 '08 #10
Error 3041 cannot open database created with a previous version of
your application.
This error also occurs when trying to create a new database in Access
2007 but in 2000 format. I still say it's the software.

Chris O'C via AccessMonster.com wrote:
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.com
http://www.accessmonster.com/Uwe/For...ccess/200809/1
Sep 24 '08 #11
It was the software. The yahoo from IT didn't install any service
packs. I downloaded and installed SP1 for Access 2007 then she had no
problems.

Chris O'C via AccessMonster.com wrote:
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.com
http://www.accessmonster.com/Uwe/For...ccess/200809/1
Sep 24 '08 #12
Good job! Access 2007 *requires* Office 2007 sp1 to fix several problems.
It may have also fixed your user's problem by reregistering the dao360.dll
and msrd3x40.dll files which, if they aren't registered properly, will cause
the error message your user was receiving.

Chris
Microsoft MVP
godiva wrote:
>It was the software. The yahoo from IT didn't install any service
packs. I downloaded and installed SP1 for Access 2007 then she had no
problems.
>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
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200809/1

Sep 24 '08 #13

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

Similar topics

27
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...
49
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),...
4
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...
17
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...
16
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...
0
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...
5
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...
4
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...
14
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...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.