Worked in Access 97 but not in Access 2000

  • Thread starter Thread starter tonyflath
  • Start date Start date
T

tonyflath

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

Users who are viewing this thread

Back
Top Bottom