By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,027 Members | 1,271 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,027 IT Pros & Developers. It's quick & easy.

Backwards Conversion

P: n/a
Folks

I bow to your superb knowledge of Access. I need you help! Please, please!

I am running Access 2002 and have an application that is basically a name
and address file with a few bells and whistles. It doesn't have any VB code.
I need to use the Access 2002 built-in tool to convert the application back
to Access 97 so that another person can use the database. When I do so the
conversion fails and says that the proposed file name is invalid, but in
fact that file name that it says is invalid (a name that it once was) is not
the name that I proposed be used.

Am I doing something wrong? I have done a search of the MS knowledge base
and there doesn't seem to be anything relevant.

Thanks in anticipation
Cheers
Maurice
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Maurice, there seems to be some kind of naming clash within your
application.

Press Ctrl+G to open the Immediate window.
On the tools menu under Options, you will see an item called
xxxx Properties
where xxxx is currently the internal name for the project.
Choose that option, and try renaming it.

If that does not work, try Compile on the Debug menu, and see if you can
identify the naming clash.

It would also be worth compacting.
From the main Database window: Tools | Database Utilities | Compact.

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

"Maurice" <ma*****@nospam.com> wrote in message
news:c0**********@lust.ihug.co.nz...
Folks

I bow to your superb knowledge of Access. I need you help! Please, please!

I am running Access 2002 and have an application that is basically a name
and address file with a few bells and whistles. It doesn't have any VB code. I need to use the Access 2002 built-in tool to convert the application back to Access 97 so that another person can use the database. When I do so the
conversion fails and says that the proposed file name is invalid, but in
fact that file name that it says is invalid (a name that it once was) is not the name that I proposed be used.

Am I doing something wrong? I have done a search of the MS knowledge base
and there doesn't seem to be anything relevant.

Thanks in anticipation
Cheers
Maurice

Nov 12 '05 #2

P: n/a
Allen

Thanks for your input, I tried all of your recommendations, however, none of
them worked.

But, I did crack the problem as follows:

In the "Tables" Section I had a link to an external table and it was that
link that caused the problem. When Access told me that I had a problem with
the filename it was referencing the name of the linked table. I used the
Linked Table Manager to "refresh" and then deleted the link, thereafter the
Convert to v1997 worked like a charm.

Cheers from Sydney Australia
Maurice
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:40**********************@freenews.iinet.net.a u...
Maurice, there seems to be some kind of naming clash within your
application.

Press Ctrl+G to open the Immediate window.
On the tools menu under Options, you will see an item called
xxxx Properties
where xxxx is currently the internal name for the project.
Choose that option, and try renaming it.

If that does not work, try Compile on the Debug menu, and see if you can
identify the naming clash.

It would also be worth compacting.
From the main Database window: Tools | Database Utilities | Compact.

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

"Maurice" <ma*****@nospam.com> wrote in message
news:c0**********@lust.ihug.co.nz...
Folks

I bow to your superb knowledge of Access. I need you help! Please, please!
I am running Access 2002 and have an application that is basically a name and address file with a few bells and whistles. It doesn't have any VB

code.
I need to use the Access 2002 built-in tool to convert the application

back
to Access 97 so that another person can use the database. When I do so the conversion fails and says that the proposed file name is invalid, but in
fact that file name that it says is invalid (a name that it once was) is

not
the name that I proposed be used.

Am I doing something wrong? I have done a search of the MS knowledge base and there doesn't seem to be anything relevant.

Thanks in anticipation
Cheers
Maurice


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.