Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unrecognized Database Format

    Strange behavior indeed, and perhaps someone out there has some insight.. <img src=/S/bummer.gif border=0 width=15 height=15>

    I have an access database which is fairly extensive, and houses some pretty important data, which is manipulated daily by one of my fellow employees.

    Recently, it became apparent that one of the reports would have to be changed, as the wording wasn't quite right. The problem is, every time I attempt to make the requested changes, I get an unrecognized database format error, followed by a slew of other errors, resulting in a complete loss of data as the tables are non-accessable. I get the same results when I attempt to repair the database, and when I try to export the tables as text, I'm getting a user-share error...

    I'd be happy to provide any other details as necessary, I can say that the programmer of this particular db, had no insight on code, and thus programmed the entire functional aspect via macro. (which may be the root of the problem...) Any feedback would be greatly appreciated!

    Thanks!
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  2. #2
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unrecognized Database Format

    Hello Drk,
    Let me ask a couple of questions. First, what version of access are you using? Is it the same version used to initially create the report? You indicate the report you inherited runs ok but needs modification. So, if you preview it, no problem. Then enter design mode make a modification, save it and preview again ... problem. Correct ? Or, are you to modifying a copy of the original report you've moved to a different database ? BTW -- The St. Pat's banner is great <img src=/S/thumbup.gif border=0 width=15 height=15>

  3. #3
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unrecognized Database Format

    Thanks, on the banner.. <img src=/S/blush.gif border=0 width=15 height=15>

    It's really odd.. it seems that to the basic user, everything is OK, they can preview, print, etc.. etc.. etc.. but when an admin goes in to attempt to change the context of a text box in the report, it goes HAYWIRE.

    Update:

    I found that the originial programmer was using Macros as opposed to code to make the database functional... as we know, macros record a bunch of extra [censored] in the code, which may cause problems. This particular database had approximate 30+ macros which made it work. I've removed the macros, and linked the main table to a stripped-down duplicate of the database. It seems to be much more stable, but is noticibly slower than it was before...
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unrecognized Database Format

    Dear DrkRealm,

    I know this is obvious but sometimes you can miss the obvious. You could try copying all the objects in to a new database. Sometimes this works. it worked for me!

  5. #5
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unrecognized Database Format

    Yeah, essentially that's what i've done..

    I took out all the macros, and patched the holes with code.. hopefully it'll work out..

    There's no test like a user's test.. <img src=/S/laugh.gif border=0 width=15 height=15>

    D
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •