A new conversion problem...

[ajames54]

Not too long ago I posted with a couple of questions
about converting Access 97 to 2000... at the time I got some help
and thought all was well... more fool me, now other people here
are coming to me for help...

Currently I'm attempting to convert an access '97 file ... I've
created a new database and imported all the fields ... everything
works fine in '97

So I copy my new database to a local drive... the file is 825 Meg
the partition on the Local drive is 4 Gig.

When I attempt to convert the file either by opening it from
explorer or by choosing the tools from Access it creates a db1
file in about 11 minutes... but the process continues,
creating a db2 file 11 minutes later...
and about 10 minutes later I get a "not enough disk space" error

db1 and db2 are identical.. I am guessing that the process is
erroring out at the end and restarting... but I have no idea.

 

[david epsom dot com dot au]

take it step by step: in A97, do a decompile, then a compact,
then use Jetcomp to compact to a Jet4 database, then open
in A2K and enable, then open in A2K and convert.

(david)

 

[ajames54]

take it step by step: in A97, do a decompile, then a compact,
then use Jetcomp to compact to a Jet4 database, then open
in A2K and enable, then open in A2K and convert.

Thanks for the help... but it seems to have gotten me a bit side
tracked... no matter what I tried Jet Compact would error out
with a simple "can't compact database" error.. I took this to
mean that there was some corruption in the database that could
not be repaired... after beating my head against that wall for a
while it occurred to me to test the app itself... I get the same
error when I attempt to compact any database... From '97 or 2000.

Are there any known issues with Jetcomp ver 4?

 

[david epsom dot com dot au]

with a simple "can't compact database" error.. I took this to

mean that there was some corruption in the database that could

I agree

Are there any known issues with Jetcomp ver 4?

No.

You will have to try importing objects from the database
into a new database, or try to find the corruption in the
database, or use an older copy from backup.

It may just be a simple case of Memo field corruption?
(caused by not using Jet SR3 with A97).


(david)

 

[ajames54]

I agree


No.

You will have to try importing objects from the database
into a new database, or try to find the corruption in the
database, or use an older copy from backup.

It may just be a simple case of Memo field corruption?
(caused by not using Jet SR3 with A97).

Nuts... I found a technet article that mentioned something about the
memo field when looking for articles refering to the "cannot find
field 'Description'" error I would get ocasionally.

Is the solution as simple as making sure I'm using Jet SR3? ( I
thought I was) ...

 

[david epsom dot com dot au]

Is the solution as simple as making sure I'm using Jet SR3? ( I

thought I was) ...

Yes, I think that's it...

Here is a simple version check routine for Windows Exe's and DLL's

(david)

---------
'David Graham. (david) Right to attribution retained.
'Watch for word wrap

Option Compare Database
Option Explicit
Const mcModuleName = "mdlRP_DLLCheck"
'2003/02/26 dlg
Private Declare Function GetFileVersionInfo& Lib "Version" Alias
"GetFileVersionInfoA" (ByVal FileName$, ByVal lptr&, ByVal lSize&, lpvData
As Any)

Public Sub gsbDLLCheck()
If ("3.51.3203.0" > gfn_GetVersion("msjet35.dll")) Then MsgBox "Warning:
MSJET35.dll is " & gfn_GetVersion("msjet35.dll") ' & ", not 3.51.3328.0"
If ("8.0.0.5903" > gfn_GetVersion("msaccess.exe")) Then MsgBox "Warning:
MSACCESS.EXE is " & gfn_GetVersion("msaccess.exe") ' & ", not 8.0.0.5903"
End Sub

Public Function gfn_GetVersion(FileName$)
'2003/02/26 dlg --minimalist version -- Right to attribution retained
Dim iBuf(0 To 99) As Integer

Call GetFileVersionInfo(FileName$, 0&, 200, iBuf(0))
gfn_GetVersion = iBuf(25) & "." & iBuf(24) & "." & iBuf(27) & "." &
iBuf(26) 'FILE VERSION

End Function

 

[ajames54]

Yes, I think that's it...

Well that is done ... What a mess. I definitely owe you a
drink..or something.

Turned out to be a combination of a couple of things..
re-installing Jet35(sp3) on the original host allowed me to run
Jet compact. (would not run at all, no idea why)

Conversion on the new host was still impossible since it ran out
of virtual memory every time that was attempted. Re-installing
the W2K and Office service packs fixed that problem.

Conversion still fails so I exported each table and converted one
at a time ... one table fails "index or primary key cannot
contain null value" I removed the index and all is well.

so I wrote a bit of code to search for null values and insert a
dummy value if found ... it found 6 null values in a table with
over 1 million records...

It's done ... all is well.