Re: MS Access mdb file

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



The owner is Admin because, apparently, everyone is logged in as Admin. This
is the default user and everyone that opens an unsecured Access database is
silently logged in as this user.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html



"Happy Day" <HappyDay@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1D11617D-8100-464D-A2EC-21CBEFA634C9@xxxxxxxxxxxxxxxx
>I have a MS Access mdb file that does not have any local Access tables. All
> the tables are linked table from MS SQL database. How come the size of the
> mdb file keep growing over time?
>
> Any question, if a MS Access talbe is created, is there a way that we can
> find out who create the table? I click on the property and the owner is
> alway
> Admin.
>
> Thanks for your help.


.



Relevant Pages

  • Re: how to detach an mdb from an mdw file?
    ... > I'm helping assess some enhancements needed for an Access/SQL Server ... > the mdw file for user security info. ... The mdb file doesn't, the Access session does. ... Access and is used by default (it silently logs you in as 'Admin' user). ...
    (microsoft.public.access.security)
  • Re: how to detach an mdb from an mdw file?
    ... So I tried you suggestion to create a new MDB file and import the objects. ... I tried the build "admin" account, and also the documented admin account in ... the domain, and the MDW file is on a server on the same domain, and SQL ... Security and will read through it this weekend. ...
    (microsoft.public.access.security)
  • Re: how to detach an mdb from an mdw file?
    ... So I tried you suggestion to create a new MDB file and import the objects. ... I tried the build "admin" account, and also the documented admin account in ... the domain, and the MDW file is on a server on the same domain, and SQL ... Security and will read through it this weekend. ...
    (microsoft.public.access.security)
  • Re: how to detach an mdb from an mdw file?
    ... So I tried you suggestion to create a new MDB file and import the objects. ... I tried the build "admin" account, and also the documented admin account in ... the domain, and the MDW file is on a server on the same domain, and SQL ... Security and will read through it this weekend. ...
    (microsoft.public.access.security)
  • Re: how to detach an mdb from an mdw file?
    ... So I tried you suggestion to create a new MDB file and import the objects. ... I tried the build "admin" account, and also the documented admin account in ... the domain, and the MDW file is on a server on the same domain, and SQL ... Security and will read through it this weekend. ...
    (microsoft.public.access.security)