Problems allowing users to create temporary tables. Insufficientpermissions.

S

SpiffW

I am using Tony Toews code (http://www.granite.ab.ca/access/
temptables.htm) to create a temporary db and table in a project that I
am working on. It works fine for me as an administrator, but none of
my other user groups can run the code. They all get run-time error
3111 could not create, no modify design
permission for table or query. Debug takes me to the following code:
______________________________________________________
' Link to the Import tables in the temp MDB
Set tdfLinked = CurrentDb.CreateTableDef(strTableName)
tdfLinked.Connect = ";DATABASE=" & strTempDatabase
tdfLinked.SourceTableName = strTableName
This line highlited -> CurrentDb.TableDefs.Append tdfLinked
________________________________________________________

I have enabled read and modify permissions for new tables/queries, but
can still only execute the code under an administrative account.
The code is being executed from the switchboard and will (when
working!) open a form that uses the temporary table as a record
source.

Thanks,
Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top