Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Access Is Unable to Load the Database Properties.

Posted on 2006-06-30
15
Medium Priority
?
419 Views
Last Modified: 2012-05-05
In several mdb's I downloaded recently, when clicking File, Database Properties, I get the subject message. I'm running A2K and the mdb's were came from a A2K3 project.  Clues?
0
Comment
Question by:GRayL
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 5
  • 4
  • +1
15 Comments
 
LVL 65

Expert Comment

by:rockiroads
ID: 17018121
Howdo

Those DB's have they been saved in A2K format? I say this because if the DB Properties were saved in A2K3, then I think that later verison stores in a different location


Also, have u tried looking at MSDN?

0
 
LVL 65

Expert Comment

by:rockiroads
ID: 17018146
Im off now, hopefully u get this resolved soon. Sounds a nasty issue.
0
 
LVL 66

Assisted Solution

by:Jim Horn
Jim Horn earned 664 total points
ID: 17018178
Hi Ray

Does you app have any CurrentDB.Properties (dao) that it depends on?  

If not, it either sounds like a corruption issue (which I'm sure you've done a R-C already), or it would probably be better to just avoid the situation and wash the database by creating a new one, and importing every object.

Hope this helps.
-Jim
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 44

Expert Comment

by:Leigh Purvis
ID: 17019073
Hi Ray

Downloaded?
From a public site?
Want to post the link - we'll have a look I'm sure.

Can you iterate through the properties collection in code without trying to do it through the File menu?
Then perhaps compare with the list of another mdb (one of your own).
See if there's a property the dialog is no doubt looking for that is ommitted (for some reason - who knows what).
But you should then be able to create it yourself if required. :-)
0
 
LVL 44

Author Comment

by:GRayL
ID: 17019288
Hi Leigh:  The site posted in this question:

http://www.experts-exchange.com/Databases/MS_Access/Q_21904654.html

I was able to iterate thru the Properties collection of the mdb.
0
 
LVL 44

Expert Comment

by:Leigh Purvis
ID: 17019299
You were able - or weren't able to? :-)
0
 
LVL 44

Author Comment

by:GRayL
ID: 17019312
I   w  a  s    a  b  l  e   t  o;-)
0
 
LVL 44

Author Comment

by:GRayL
ID: 17019357
I think rocki has it.  I'll bet even though an mdb created in Access 2003 is saved in an A2K format, there will be things like database properties that you call from File, Database Properties ( not the same as currentdb.properties) that are not converted.  I'll leave this open for a day or so to see if anyone can confirm that A2K cannot open those properties of a A2003 mdb.  I was just trying to look at the size of the mdb - for Pete's sake!
0
 
LVL 44

Expert Comment

by:Leigh Purvis
ID: 17019365
OK.
Just checking... :-)

(I'd just sensed a kinda
"Do you know where the TV remote is?"
"Yes thanks"
moment ;-)

having at look the mdb now.
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 17020480
I dont have A2K to verify
So much for having the latest s/w
0
 
LVL 44

Accepted Solution

by:
Leigh Purvis earned 672 total points
ID: 17020533
I've checked and it does open fine in 2003.
It also opens with the error as reported in 2000 (SP3) and the same error in 2000 (no service packs).

Importing everything into a new mdb in 2000 fixed it fine (no surprise there)...
But that doesn't help us solve the mystery... which is annoying.
0
 
LVL 65

Assisted Solution

by:rockiroads
rockiroads earned 664 total points
ID: 17020565
Behaviour Design

Design Feature

call it what u like

come on man, MS dont do bugs
0
 
LVL 44

Author Comment

by:GRayL
ID: 17024808
OK, I did the same thing.  Here's the results.  When you download a A2003 mdb, it has to be saved in A2K format.  However, that format does not allow A2K to look at the mdb properties in the File, Database Properties method.  But, when you create a new A2K mdb and import all the items, the problem goes away.  I'm happy with an explanation of another MS Design Feature.  You all had a hand in coming to that concusion so a three way split.
0
 
LVL 44

Expert Comment

by:Leigh Purvis
ID: 17025103
I'd certainly say that *something* happened to that online mdb though.
You should be (and are usually) able to create a 2K format mdb in 2K3 - and open it in A2K, and view the properties.

Sounds like a peculiarity this one - rather than the norm. :-S
0
 
LVL 44

Author Comment

by:GRayL
ID: 17025230
Hi Leigh:  I generalised at bit.  I actually had two problematic mdb's from an A2K3 app that gave me that problem until I created a new mdb, and imported all the objects into the new mbd.  I was then able to File, Database Properties in the new mdb no prob.  I really believe it is a problem with A2K3 saving an mdb in A2K format.  Most of it works, but as Rocki said - a design feature.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

664 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question