[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Help! Access 97 to Access 2000 problems...

Posted on 2004-10-27
38
Medium Priority
?
216 Views
Last Modified: 2008-02-01
I have not looked at Access in 10 years and now need to convert a database from 97 to 2000.

Having many problems, but the biggest one is with my memory. Can someone tell me why I cannot open in design mode the database once brought into 2000? The app has an mdw file which I joined to the workgroup and I'm using the administrators ID, but I cannot see how to look at the table/forms...etc?

What am I missing?

Thanks need quick answers if possible.
0
Comment
Question by:surfsista9
[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
  • 16
  • 13
  • 6
  • +2
38 Comments
 
LVL 3

Expert Comment

by:Leo Alexander
ID: 12424887
If you are opening the 97 database in the 2000 one,

go to tools > database utilities > convert database
0
 

Author Comment

by:surfsista9
ID: 12424945
Well,

Many months ago I went through this exercise. Now I'm trying to go in under 2000 but I cannot get to the structure, the forms, reports, tables. Why is this?
0
 
LVL 4

Expert Comment

by:CrossWired
ID: 12424994
So the database is converted but you want to see the talbes and forms and stuff which are probally hidden
Goto  Window > Unhide and select the main database

0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

Author Comment

by:surfsista9
ID: 12425041
I don't get the option to do a window/unhide
0
 
LVL 4

Expert Comment

by:CrossWired
ID: 12425061
Can you goto Tools > Startup?

If so there is an Option to Show Database Window - check that and restart your database

0
 

Author Comment

by:surfsista9
ID: 12425074
The application is running...I have a shortcut that joins the wrkgroup containing the admin ID...but this doesn't seem to be getting me in.
0
 

Author Comment

by:surfsista9
ID: 12425083
I only see the application menu, not Access menu.
0
 
LVL 4

Expert Comment

by:CrossWired
ID: 12425098
So you're not even logged into the database yet?
0
 

Author Comment

by:surfsista9
ID: 12425120
I'm in run mode...not design mode...

The application is running.
0
 
LVL 39

Expert Comment

by:stevbe
ID: 12425136
have you tried holding the shift key while opening the database?
If this still does not work then that option may have been turned off in code and you will need to reset it.
http://www.mvps.org/access/general/gen0040.htm

Steve
0
 
LVL 4

Expert Comment

by:CrossWired
ID: 12425138
I'm not sure where exactly you are, could you zip it and send it to me and let me take a look?
0
 

Author Comment

by:surfsista9
ID: 12425201
well, no can't do that...it's propriatary.

Let me ask another question. If I want to convert from 97 to 2000 and get a permissions error, how do I work around this?
0
 
LVL 39

Expert Comment

by:stevbe
ID: 12425246
First, I would de-secure and import eveything into a new 97 database, convert up to 2000 and resecure.

Steve
0
 
LVL 4

Expert Comment

by:CrossWired
ID: 12425265
Okay how about this, instead of Converting the database, have you tried IMPORTING all the forms, reports, tables into a new 2000 database.
0
 
LVL 4

Expert Comment

by:CrossWired
ID: 12425274
Stevbe,
  I'm curious why import to 97 vice straight to 2000?  

Jay
0
 
LVL 39

Expert Comment

by:stevbe
ID: 12425337
You could try joining the workgroup in 2000 and then import everything, I'm not saying doing that would not work, security can be picky ... I like to do things in small steps.

Steve
0
 
LVL 4

Expert Comment

by:CrossWired
ID: 12425357
ahh okay, makes sense enough
0
 

Author Comment

by:surfsista9
ID: 12425873
Alright...I imported and it's 2002, not 2000...sorry, I haven't looked at Access in many moons. Now I have the security out of the picture, here is my real issue...

The guy who wrote this app uses MSAU7032.DLL to open explorer folders but for some reason, even though this dll is on the machine, I get a not found error. I'm assuming maybe some dependency is missing that this dll needs to do it's job. I think this came with the developer toolkit for 97. Where/how do I get all the dependencies needed to run this? I've looked everywhere for downloads, cannot find it out there. I tried registering the dll but I get a registry error.

Any ideas...you guys are GREAT for helping me out.

0
 
LVL 4

Expert Comment

by:CrossWired
ID: 12425899
To browse for Folders I use

Private Type BROWSEINFO
  hOwner As Long
  pidlRoot As Long
  pszDisplayName As String
  lpszTitle As String
  ulFlags As Long
  lpfn As Long
  lParam As Long
  iImage As Long
End Type

Private Declare Function SHGetPathFromIDList Lib "shell32.dll" Alias _
            "SHGetPathFromIDListA" (ByVal pidl As Long, _
            ByVal pszPath As String) As Long
           
Private Declare Function SHBrowseForFolder Lib "shell32.dll" Alias _
            "SHBrowseForFolderA" (lpBrowseInfo As BROWSEINFO) _
            As Long
           
Private Const BIF_RETURNONLYFSDIRS = &H1

Public Function BrowseFolder(szDialogTitle As String) As String
  Dim X As Long, bi As BROWSEINFO, dwIList As Long
  Dim szPath As String, wPos As Integer
 
    With bi
        .hOwner = hWndAccessApp
        .lpszTitle = szDialogTitle
        .ulFlags = BIF_RETURNONLYFSDIRS
    End With
   
    dwIList = SHBrowseForFolder(bi)
    szPath = Space$(512)
    X = SHGetPathFromIDList(ByVal dwIList, ByVal szPath)
   
    If X Then
        wPos = InStr(szPath, Chr(0))
        BrowseFolder = Left$(szPath, wPos - 1)
    Else
        BrowseFolder = vbNullString
    End If
End Function

0
 

Author Comment

by:surfsista9
ID: 12425910
that's cool, thanks....but this app is using MSAU7032.DLL all over the place and I prefer not to rewrite anything if possible.

Any other ideas? Keep em coming please...I need all the help I can get.
0
 
LVL 4

Expert Comment

by:CrossWired
ID: 12425942
Sorry usage:

    folderLoc = BrowseFolder("What Folder you want to select?")

0
 

Author Comment

by:surfsista9
ID: 12425968
there are other functions created from this dll and others...so would prefer not to rewrite the code.
0
 
LVL 39

Expert Comment

by:stevbe
ID: 12426012
Is MSAU7032.dll listed as a reference or are you making a direct api call?
If it was a reference then from any code window Tool --> References, there probably is a "MISSING" one. Uncheck and then either scroll through the list or use Browse to navigate to the file.

Steve
0
 
LVL 4

Expert Comment

by:CrossWired
ID: 12426015
ohh okay, is the dll registered?

try regsvr32 MSAU7032.DLL

0
 

Author Comment

by:surfsista9
ID: 12426028
yes, as I said, tried that...get a registry error. I think there may be dependencies...but don't know???
0
 

Author Comment

by:surfsista9
ID: 12426086
I don't see Tool ----> References enabled in any module or form. Why is that?

Anyway, it looks like a direct call...

Declare Function glr_msauSortStringArray Lib "MSAU7032.DLL" Alias "#403" _
 (astr() As String) As Long
' Sort an array of db objects.
Declare Function glr_msauSortDbobjArray Lib "MSAU7032.DLL" Alias "#404" _
 (atypDBObj() As glrDBObj, ByVal fNamesOnly As Long) As Long
 
0
 
LVL 4

Expert Comment

by:CrossWired
ID: 12426130
Is it possible that a different version of MSAU7032.DLL was used than the one you have currently?
0
 

Author Comment

by:surfsista9
ID: 12426135
oops..sorry, I was in run mode...found references and no, the dll is not referenced there.
0
 

Author Comment

by:surfsista9
ID: 12426144
Anything is possible. But wonder why I cannot register it? Makes me think some other dll's are missing.
0
 
LVL 39

Expert Comment

by:stevbe
ID: 12426164
hmmm ... what version of OS ... I have 2000 witrh Access 2002 and do not have that fiel, the only references to it I could find are for Access 95 so the dll itself may not work in OS higher than 95 :-(

Have you tried unregistering and re-regisdtering ... what id the registry error? Do you have permission to write to the registry?

Steve
0
 
LVL 4

Expert Comment

by:CrossWired
ID: 12426174
But that shouldn't be aproblem since like you said they are direct calls
0
 

Author Comment

by:surfsista9
ID: 12426212
yes, I have full admin privileges...I'm a developer but not an Access developer.

The registry error is:
LoadLibrary("c:\winnt\system32\msau7032.dll") failed - The specified module could not be found.

sounds like a dependency is missing to me.
0
 

Author Comment

by:surfsista9
ID: 12426239
This worked for the user on her old machine...running Access 97. She got a new machine and now has the problem. It never worked on my machine.
0
 
LVL 4

Expert Comment

by:CrossWired
ID: 12426300
You said that other functions use the msau7032.dll, do they work or is it just this funciton of it?
0
 
LVL 39

Expert Comment

by:stevbe
ID: 12426340
msau7032.dll actually was distributed with Access and I don't think there were any other dependanceies ...

did you try

regsvr32 "c:\winnt\system32\msau7032.dll"

from Run?

Steve
0
 

Author Comment

by:surfsista9
ID: 12426394
Nope...that is what I did...as I said, cannot register and I am making a direct call so this should not matter either way.

CrossWired,

I checked and apparently the app does not use the other declarations of msau7032.dll
in the basMSAU7032 module.
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 13161573
PAQed with points refunded (500)

modulo
Community Support Moderator
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
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.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

649 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