Cannot Convert Access 2002 DB To Access 2007

[FlyGuy]

I have a very small, simple Access DB that converts web site log files into
easy to read Access reports.

I can open and use the 2002 version in 2007 just fine, but every attempt to
convert to 2007 file format fails and generates an error message that says
the file is already in use by [me] on my PC.

I've tried opening exclusively, etc; nothing helps.

So the conversion never happens.

I am the only user [and am the admin] on the PC.

Any insight or suggestions would be appreciated.

I have been able to make a new, blank 2007 DB and import all objects; but
even with correct references set, this line of code always fails in 2007 bit
works in the 2002 version when run in 2007 ...

DoCmd.TransferText acImportFixed, "LogImportSpecs", "tblRawData", TempFile

Running the module with this line generates an error that "LogImportSpecs"
is not defined.

In the 2002 version, in that module (that works), I cannot find any
defination for "LogImportSpecs"; it is also not found in 2007 module (that
doesn't work).

Unfortunately, I created the DB so long ago I cannot remember what the
"LogImportSpecs" references.

There are no DB objects with the name "LogImportSpecs".

So I was hoping that a simple conversion (not importing) might solve the
issue.

 

[Allen Browne]

Suggestions:

1. While the database is NOT open, delete any LDB file in the same folder as
the database. (The LDB contains locking info.)

2. Temporarily clear any Start Up form you have defined, and rename any
AutoExec macro.

3. Perform the maintenance steps suggested here:
http://allenbrowne.com/recover.html

4. If you are still stuck, see:
http://www.access.qbuilt.com/html/conversion.html#CannotMakeMDE

 

[Tom Wickerath]

Hi FlyGuy,

I can open and use the 2002 version in 2007 just fine, but every attempt to
convert to 2007 file format fails and generates an error message that says
the file is already in use by [me] on my PC.

Try opening your 2002 version in Access 2007, but first hold down the shift
key. Keep the shift key held down the entire time that Access 2007 is
opening. You should not see any form open automatically. Then, without
opening any object (form, report, etc.) immediately attempt the conversion.

Running the module with this line generates an error that "LogImportSpecs"
is not defined.

You need to check the option to import the saved specifications. These are
saved in a normally hidden system table, so that's why you haven't found them
before, when looking for them. In Access 2007, select the External Data tab
of the ribbon. Then click on Access in the Import group. Browse to the Access
2002 version of your database, with the Import option selected. On the Tables
tab, click on the button labelled "Options >>". Check the option that reads
"Import/Export Specs". That should fix the error in your code.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

I have a very small, simple Access DB that converts web site log files into
easy to read Access reports.

I can open and use the 2002 version in 2007 just fine, but every attempt to
convert to 2007 file format fails and generates an error message that says
the file is already in use by [me] on my PC.

I've tried opening exclusively, etc; nothing helps.

So the conversion never happens.

I am the only user [and am the admin] on the PC.

Any insight or suggestions would be appreciated.

I have been able to make a new, blank 2007 DB and import all objects; but
even with correct references set, this line of code always fails in 2007 bit
works in the 2002 version when run in 2007 ...

DoCmd.TransferText acImportFixed, "LogImportSpecs", "tblRawData", TempFile

Running the module with this line generates an error that "LogImportSpecs"
is not defined.

In the 2002 version, in that module (that works), I cannot find any
defination for "LogImportSpecs"; it is also not found in 2007 module (that
doesn't work).

Unfortunately, I created the DB so long ago I cannot remember what the
"LogImportSpecs" references.

There are no DB objects with the name "LogImportSpecs".

So I was hoping that a simple conversion (not importing) might solve the
issue.

 

[FlyGuy]

Allen, thanks very much for the suggestion to clear out any start up form; I
had a Switchboard opening on load.

After I elected "none" for a startup form, I was able to convert.

Converting also fixed the import code not working.

--
Thanks,

FlyGuy

Suggestions:

1. While the database is NOT open, delete any LDB file in the same folder as
the database. (The LDB contains locking info.)

2. Temporarily clear any Start Up form you have defined, and rename any
AutoExec macro.

3. Perform the maintenance steps suggested here:
http://allenbrowne.com/recover.html

4. If you are still stuck, see:
http://www.access.qbuilt.com/html/conversion.html#CannotMakeMDE

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have a very small, simple Access DB that converts web site log files
into
easy to read Access reports.

I can open and use the 2002 version in 2007 just fine, but every attempt
to
convert to 2007 file format fails and generates an error message that says
the file is already in use by [me] on my PC.

I've tried opening exclusively, etc; nothing helps.

So the conversion never happens.

I am the only user [and am the admin] on the PC.

Any insight or suggestions would be appreciated.

I have been able to make a new, blank 2007 DB and import all objects; but
even with correct references set, this line of code always fails in 2007
bit
works in the 2002 version when run in 2007 ...

DoCmd.TransferText acImportFixed, "LogImportSpecs", "tblRawData", TempFile

Running the module with this line generates an error that "LogImportSpecs"
is not defined.

In the 2002 version, in that module (that works), I cannot find any
defination for "LogImportSpecs"; it is also not found in 2007 module (that
doesn't work).

Unfortunately, I created the DB so long ago I cannot remember what the
"LogImportSpecs" references.

There are no DB objects with the name "LogImportSpecs".

So I was hoping that a simple conversion (not importing) might solve the
issue.

.

 

[FlyGuy]

Hi Tom, thank you very much for the suggestion.

I had a Switchboard opening on load.

After I elected "none" for a startup form, I was able to convert.

Converting also fixed the import code not working.

I note that, after converting, when the Switchboard was opening in
"overlapping windows" mode, the Access title bar did not indicate the file
version as 2007.

I switched to tabbed view, and the file type now shows.

--
Thanks,

FlyGuy

Hi FlyGuy,

I can open and use the 2002 version in 2007 just fine, but every attempt to
convert to 2007 file format fails and generates an error message that says
the file is already in use by [me] on my PC.

Try opening your 2002 version in Access 2007, but first hold down the shift
key. Keep the shift key held down the entire time that Access 2007 is
opening. You should not see any form open automatically. Then, without
opening any object (form, report, etc.) immediately attempt the conversion.

Running the module with this line generates an error that "LogImportSpecs"
is not defined.

You need to check the option to import the saved specifications. These are
saved in a normally hidden system table, so that's why you haven't found them
before, when looking for them. In Access 2007, select the External Data tab
of the ribbon. Then click on Access in the Import group. Browse to the Access
2002 version of your database, with the Import option selected. On the Tables
tab, click on the button labelled "Options >>". Check the option that reads
"Import/Export Specs". That should fix the error in your code.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

I have a very small, simple Access DB that converts web site log files into
easy to read Access reports.

I can open and use the 2002 version in 2007 just fine, but every attempt to
convert to 2007 file format fails and generates an error message that says
the file is already in use by [me] on my PC.

I've tried opening exclusively, etc; nothing helps.

So the conversion never happens.

I am the only user [and am the admin] on the PC.

Any insight or suggestions would be appreciated.

I have been able to make a new, blank 2007 DB and import all objects; but
even with correct references set, this line of code always fails in 2007 bit
works in the 2002 version when run in 2007 ...

DoCmd.TransferText acImportFixed, "LogImportSpecs", "tblRawData", TempFile

Running the module with this line generates an error that "LogImportSpecs"
is not defined.

In the 2002 version, in that module (that works), I cannot find any
defination for "LogImportSpecs"; it is also not found in 2007 module (that
doesn't work).

Unfortunately, I created the DB so long ago I cannot remember what the
"LogImportSpecs" references.

There are no DB objects with the name "LogImportSpecs".

So I was hoping that a simple conversion (not importing) might solve the
issue.

 

[GeoffG]

Allen,

Very many thanks for building a wonderful website for Access
developers.

This article is a stunning revelation:
http://allenbrowne.com/ser-47.html#SaveAsText

Happy New Year
Geoff

Suggestions:

1. While the database is NOT open, delete any LDB file in
the same folder as the database. (The LDB contains locking
info.)

2. Temporarily clear any Start Up form you have defined,
and rename any AutoExec macro.

3. Perform the maintenance steps suggested here:
http://allenbrowne.com/recover.html

4. If you are still stuck, see:

http://www.access.qbuilt.com/html/conversion.html#CannotMakeMDE

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.


message

I have a very small, simple Access DB that converts web
site log files into
easy to read Access reports.

I can open and use the 2002 version in 2007 just fine,
but every attempt to
convert to 2007 file format fails and generates an error
message that says
the file is already in use by [me] on my PC.

I've tried opening exclusively, etc; nothing helps.

So the conversion never happens.

I am the only user [and am the admin] on the PC.

Any insight or suggestions would be appreciated.

I have been able to make a new, blank 2007 DB and import
all objects; but
even with correct references set, this line of code
always fails in 2007 bit
works in the 2002 version when run in 2007 ...

DoCmd.TransferText acImportFixed, "LogImportSpecs",
"tblRawData", TempFile

Running the module with this line generates an error that
"LogImportSpecs"
is not defined.

In the 2002 version, in that module (that works), I
cannot find any
defination for "LogImportSpecs"; it is also not found in
2007 module (that
doesn't work).

Unfortunately, I created the DB so long ago I cannot
remember what the
"LogImportSpecs" references.

There are no DB objects with the name "LogImportSpecs".

So I was hoping that a simple conversion (not importing)
might solve the
issue.

 

[Allen Browne]

Great. Feedback appreciated.

Enjoy 2010.