TransferSpreadsheet gives me "Error; could not create" for ImportErrors temp table
I am using the following code to import an Excel 2003 spreadsheet with a single worksheet (ie: one tab only) into a security-enabled Access 2003 database.
DoCmd.TransferSpreadsheet acImport, , TEMP_SIMPLE_MASTER_TABLE, sFileName, True
TEMP_SIMPLE_MASTER_TABLE is a string constant naming the table to import into. This table is static, it is never dropped (deleted) but rather cleared before every import.
When I log in as admin, the import works fine, there are some "sheet1_$importerror" files created - fair enough.
When I log in as a custom user "testmasterload" though, that belongs to a group with significantly reduced permissions, I get the error message:
"Error: could not create; no modify design permission for table or query 'Sheet1$_ImportErrors"
The testmasterload user belongs to "Master Loaders Group" which has the following permissions:
Database: Open/Run
Table | New Tables/Queries: Read Design/ Modify Design + CRUD
Can anyone tell me what minimum permissions I have to grant for these import error tables to be created? I cannot give the group "administer" level rights.
This is where I expect you will ask why I want to compensate for import errors. Simple, the field that causes import error is a calculated field, contains a VLOOKUP and no matter if I use text(255) or memo datatypes which I consider to be catch-all, an import error is still created. This import error table NEEDS to be created but I don't want to give the user too many rights.
I am using the following code to import an Excel 2003 spreadsheet with a single worksheet (ie: one tab only) into a security-enabled Access 2003 database.
DoCmd.TransferSpreadsheet acImport, , TEMP_SIMPLE_MASTER_TABLE, sFileName, True
TEMP_SIMPLE_MASTER_TABLE is a string constant naming the table to import into. This table is static, it is never dropped (deleted) but rather cleared before every import.
When I log in as admin, the import works fine, there are some "sheet1_$importerror" files created - fair enough.
When I log in as a custom user "testmasterload" though, that belongs to a group with significantly reduced permissions, I get the error message:
"Error: could not create; no modify design permission for table or query 'Sheet1$_ImportErrors"
The testmasterload user belongs to "Master Loaders Group" which has the following permissions:
Database: Open/Run
Table | New Tables/Queries: Read Design/ Modify Design + CRUD
Can anyone tell me what minimum permissions I have to grant for these import error tables to be created? I cannot give the group "administer" level rights.
This is where I expect you will ask why I want to compensate for import errors. Simple, the field that causes import error is a calculated field, contains a VLOOKUP and no matter if I use text(255) or memo datatypes which I consider to be catch-all, an import error is still created. This import error table NEEDS to be created but I don't want to give the user too many rights.