Thanks...
because that method just create a copy of my file and I can't copy my tables data from it because as i mentioned i can't access to my tables.
can you explain a little more about DoCmd.TransferSpreadsheet ??
Hi everyone, have nice day
I want to export my tables data in a backup file and use it later.
how can i do this with vba codes??
Please note that i don't want use copyfile method in vba but i want to create simple backup from data in my tables.
Help me pls, thanks
Hi, have nice day
I'm new in access and have problem with write conflict error, I use this code for update my table :
cmd = "UPDATE TblStudent SET Student_Image = '" + fileName + "' WHERE Student_ID_ = " + Student_ID
DoCmd.RunSQL cmd
But everytime i face with this error :
This record has...