Can't Import to Secure Database

  • Thread starter Thread starter EM.Bateman
  • Start date Start date
E

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?
 
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?
 
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.
 
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?
 
Back
Top