D
Desperate in Danbury
Greetings,
I use Access 2000 and have been handed a database created
in a prior version. I'm not COMPLETELY unfamiliar with
Access, but this is the first time I've used it.
The database has an unusual setup and I'm not sure how best
to proceed, I'm hoping someone here can advise me.
It's set up with an .mde file that is used as the User
Interface and an .mdb file that is the 'actual' database.
To enter data, you run the mde file which pops up a data
entry form, and all data is actually stored in the mdb file
(It's a linked table).
There are two passwords, if you enter the User password,
you're greeted with the Form View of the input page and
don't have access to anything else. If you enter the Admin
password you see the view that shows the object list
(queries, forms, etc) on the left and the actual objects on
the right. You have, at that point, full power to do as
you please.
The mde file was created by someone with little experience
and he never deleted ANYTHING he'd created "just in case"
which means that the mde file is 90Meg (while the database
itself is about 3 Meg). The HUGE mde file seemed to slow
things down, so I started stripping things away and got to
the core of what we actually use. All is well up to this
point.
Even though I've stripped a TON of stuff out, the mde file
STILL shows up as being 90 Meg, and I can't seem to find a
way to make it shrink (I tried Compact & Repair, but after
letting it sit halfway through the compact for nearly an
hour, figured I wasn't getting anywhere and closed Access).
Not to be deterred, I created a NEW file and simply copied
over the objects that I need from the original. What WAS
90Meg is now 1.8Meg... good news. But I can't figure out
how he set up the two passwords. I know both, of course,
but since I signed in using Admin, it only seems to let me
see the Admin stuff. I can't get my new, smaller mde file
to password-prompt the same as the original file. Since I
can simply open the mdb file and edit it, it appears it's
not password protected, only the mde file (I think he
converted the other to mde just to make it very clear which
one is which).
SO... any ideas on how to either get the original that I
trimmed 'compacted' so that it's not 90 Meg or figure out
how to set up dual password entry with each password giving
a different view and permissions???
Any help would be appreciated,
Desperate
I use Access 2000 and have been handed a database created
in a prior version. I'm not COMPLETELY unfamiliar with
Access, but this is the first time I've used it.
The database has an unusual setup and I'm not sure how best
to proceed, I'm hoping someone here can advise me.
It's set up with an .mde file that is used as the User
Interface and an .mdb file that is the 'actual' database.
To enter data, you run the mde file which pops up a data
entry form, and all data is actually stored in the mdb file
(It's a linked table).
There are two passwords, if you enter the User password,
you're greeted with the Form View of the input page and
don't have access to anything else. If you enter the Admin
password you see the view that shows the object list
(queries, forms, etc) on the left and the actual objects on
the right. You have, at that point, full power to do as
you please.
The mde file was created by someone with little experience
and he never deleted ANYTHING he'd created "just in case"
which means that the mde file is 90Meg (while the database
itself is about 3 Meg). The HUGE mde file seemed to slow
things down, so I started stripping things away and got to
the core of what we actually use. All is well up to this
point.
Even though I've stripped a TON of stuff out, the mde file
STILL shows up as being 90 Meg, and I can't seem to find a
way to make it shrink (I tried Compact & Repair, but after
letting it sit halfway through the compact for nearly an
hour, figured I wasn't getting anywhere and closed Access).
Not to be deterred, I created a NEW file and simply copied
over the objects that I need from the original. What WAS
90Meg is now 1.8Meg... good news. But I can't figure out
how he set up the two passwords. I know both, of course,
but since I signed in using Admin, it only seems to let me
see the Admin stuff. I can't get my new, smaller mde file
to password-prompt the same as the original file. Since I
can simply open the mdb file and edit it, it appears it's
not password protected, only the mde file (I think he
converted the other to mde just to make it very clear which
one is which).
SO... any ideas on how to either get the original that I
trimmed 'compacted' so that it's not 90 Meg or figure out
how to set up dual password entry with each password giving
a different view and permissions???
Any help would be appreciated,
Desperate