This is being called elsewhere, but it fails at the transferspreadsheet. The rest of the code that calls it just does a bunch of docmd's to run queries to update/append/clean up. Those dont do anything "special".
Run time error with importing after splitting database (1 Viewer)
- Thread starter tmyers
- Start date
- Local time
- Yesterday, 18:31
- Joined
- Feb 28, 2001
- Messages
- 27,138
OK, if the back end is a native Access database on a BE server, once that file is in place, you need to determine your effective permissions on the file. Using standard exploration methods, right-click on the BE file, >> Properties >> Security >> Effective Permissions. You will have to select your own username. What you SHOULD have is (a) MODIFY permissions on the BE file and (b) MODIFY permissions on the folder holding the BE on that server. If you have MODIFY on one but not the other, then we are looking at an inability to do something at a basic file-system permissions level. I could go crazy here on an explanation but if the permissions are OK, then there is no need for my particular craziness to kick in.
