Worked in Access 97 but not in Access 2000

[tonyflath]

The code I used in Access 97 is included at the end. On Case 3 it would return files with '*.imp' extension. i.e. 'Exportfile.imp'. I converted the database to Access 2000 and now the '*.imp' does not work. I get the following error message: '3027: Cannot Update. Database or Object is read only. Any help is surely appreciated. Thanks.

Code that worked in Access 97:

Set db = CodeDb
Select Case pintFileType
Case 1
strFileType = ".csv"
Case 2
strFileType = ".txt"
Case 3
strFileType = ".imp"

 

[Pat Hartman]

Refer to the post I made recently. I think it will explain your problem.
http://www.access-programmers.co.uk/ubb/Forum1/HTML/003316.html

 

[Atomic Shrimp]

Does A2K let you export the file as .txt then rename it using the Name statement?

I've reverted to A97 after running into a whole raft of issues just like this.

 

[Pat Hartman]

Yes, I seem to have left off that part of my solution. Export the file as .txt (or whatever valid extension seems appropriate) and then use Name to rename it.