Can't Import to Secure Database

[EM.Bateman]

I have a database that I've set up with two security groups - the
first is read-only access for general users, the second is an Admin
account that should allow full access. I used the instructions that
have been posted here a few times.

My problem now is that when I log in as the admin, using the password,
I can no longer import excel data into established tables. I get an
error that I don't have "permission" to import to <tablename>.

How can I fix this?

 

[Joan Wild]

By admin do you mean the built-in 'Admin' account or some username you have
created that is a member of the Admins Group.

If the former, the 'Admin' user shouldn't have any permissions to anything
in the database.

If it is a separate user, then what permissions does that user have on the
Database object, and the table in question?

 

[EM.Bateman]

It is a separate account set up with a username and password - not the
default admin. The separate account was set up to have full access to
all objects and data.

 

[Joan Wild]

From your description, this user should have no problem importing from
Excel. Double-check the permissions this user has, and also any groups they
are a member of.

Are you able to import from Excel to a new table, and then append?