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.
--
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/co...#CannotMakeMDE

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"FlyGuy" <(E-Mail Removed)> wrote in message
news:E2421AFE-FD69-462E-AFCA-(E-Mail Removed)...
> 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.
> --
> 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/
__________________________________________

"FlyGuy" wrote:

> 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.
> --
> Thanks,
>
> 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


"Allen Browne" wrote:

> 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/co...#CannotMakeMDE
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
>
> "FlyGuy" <(E-Mail Removed)> wrote in message
> news:E2421AFE-FD69-462E-AFCA-(E-Mail Removed)...
> > 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.
> > --
> > Thanks,
> >
> > 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


"Tom Wickerath" wrote:

> 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/
> __________________________________________
>
> "FlyGuy" wrote:
>
> > 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.
> > --
> > Thanks,
> >
> > FlyGuy

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




"Allen Browne" <(E-Mail Removed)> wrote in message
news:uM$j#(E-Mail Removed)...
> 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/co...#CannotMakeMDE
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
>
> "FlyGuy" <(E-Mail Removed)> wrote in
> message
> news:E2421AFE-FD69-462E-AFCA-(E-Mail Removed)...
>> 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.
>> --
>> Thanks,
>>
>> FlyGuy
>

Great. Feedback appreciated.

Enjoy 2010.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"GeoffG" <(E-Mail Removed)> wrote in message
news:#(E-Mail Removed)...
> 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