Can't open my Access files after conversion from Access 97 to Access 2003

[M Shafaat]

Hi,
After I converted my MS Access files from ver 97 to 2003, I cannot open them
anymore.



How can I resolve this problem?



I run Windows XP Pro SP 3.



Regards
M Shafaat

 

[Jeff Boyce]

It isn't clear what's happening when you try ... more information, please.

Are you attempting to open them with Access '97 or with Access 2003?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[M Shafaat]

Sorry for too thin info. Here is more info:
I open the files with Access 2003. Access tells me that I don't have the
permission to open them. With some other files it allows me to open them in
read-only mode. Så it must be a security action from Access by some reason,
I usually don't sign my files digitally.



Thank you for your help
M Shafaat

 

[Jeff Boyce]

I haven't run across this before ... hopefully other readers have some
insight.

Good luck

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Tom Wickerath]

Strange. Try creating a brand new database in Access 2003. I recommend
disabling NameAutocorrect first thing (Tools | Options... > General tab).
Also recommended: disable the AutoIndexing "feature" by clearing the
suggested fieldname fragments from Auto Index on Import / Create text box
found on the Tables/Queries tab.

Then try importing each group of objects from your Access 97 source file.

Use File | Get External Data | Import...

to start this procedure. Note that you will not be able to see any hidden
objects in the import dialog, so you may want to first use Access 97 to
ensure that none of your objects have been set as hidden.


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

 

[John W. Vinson]

Sorry for too thin info. Here is more info:
I open the files with Access 2003. Access tells me that I don't have the
permission to open them. With some other files it allows me to open them in
read-only mode. Så it must be a security action from Access by some reason,
I usually don't sign my files digitally.

Did you have Workgroup Security implemented? Is there a file on your computer
(perhaps in C:\Windows\System32, perhaps elsewhere) with a .mdw extension,
other than the default SYSTEM.MDW which should always be there? When you used
the databases in A97 were you prompted for a userid and password?