|
-
Mar 3rd, 2001, 12:54 PM
#1
Thread Starter
Addicted Member
Dear all,
I have a problem that confuse me a long time. In the past, JamesM suggests me to use:
' Use the TransferText method of Access for importing text data
Dim accApp As Access.Application
Set accApp = New Access.Application
accApp.OpenCurrentDatabase App.Path & "\database\" & MyDatabaseName & ".mdb", True
accApp.DoCmd.TransferText acImportDelim, "Default Import Specification", MyTableName, MyDataFilePath, True
to import data file into an Access database.
That's OK in the past. But for unknown reasons, it can't work now because of the error:
Error 3027
Cannot update. Database or object is read-only.
But I have checked the property of the mdb file is archive not read only.
I have tried this code both 97 and 2000 and previously work but recently it can't work
Can you help help me please.
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|