Creating reports from within Excel using Access data

[Guest]

Please help me with the following question. I am trying to import data into
Excel from an Access database. I have administrative rights - the database is
on a network. It keeps asking me for Admin/Password - there is no user named
'admin' on my database as I have renamed it. I put my adminname and password
and it just keeps coming back with 'you do not have permission message'. It
works fine when I use a stand alone database, just not with a network one.
There must be an explanation for this somewhere, but I have looked everywhere
and can't find one. Thanks

 

[Arvin Meyer [MVP]]

Please help me with the following question. I am trying to import data into
Excel from an Access database. I have administrative rights - the database is
on a network. It keeps asking me for Admin/Password - there is no user named
'admin' on my database as I have renamed it. I put my adminname and password
and it just keeps coming back with 'you do not have permission message'. It
works fine when I use a stand alone database, just not with a network one.
There must be an explanation for this somewhere, but I have looked everywhere
and can't find one. Thanks

admin is the default owner/user of all Access databases. By renaming the
admin user, you have caused the behind-the-scenes security to be involked
and the system.mdw is asking for the credentials. The reason it works on
your system is that you have changed your security to allow it. I strongly
suggest that you read, and re-read, the Access security FAQ before
unsecuring your database or you will soon find yourself unable to get into
it at all. Here is the link:

http://support.microsoft.com/support/access/content/secfaq.asp
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

well thank you - that's interesting and at the same time confusing because I
just follwed exactly what Access tells you to do:

QUOTE from directed page:
Because the Admin account is a default account, which is identical across
all Microsoft Access installations, you do need to remove it from the Admins
group as part of the process of helping protect the database. You want Admin
to be merely another member of the Users group. You then remove all
permissions from the Users group, so Admin inherits nothing (you assign
permissions only to your custom groups). If you neglect this step, your
database will never be secure.

Well I havent deleted the Admin just not using it - so am I missing
something here?

Thanks