By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,027 Members | 1,199 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,027 IT Pros & Developers. It's quick & easy.

Several questions and some pain

P: n/a
Ron
Hi All,

First question is what to do if somehow security was run on a database I've
designed and yet I have NO idea how or when it was run? There is a
"system1.mdw" file sitting there, and I think it's been there since day one
when I started playing around with Access 2000 back a couple years ago. Any
way to circumvent the security settings? Cancel the settings so they aren't
even there (as, I don't need them anyway...)?

The reason I ask, is that I started using Tony Toew's Auto FE Updater and
was having problems due to "security settings" which was a real surprise.
When starting database on the 2nd machine it was saying I didn't have the
"necessary permissions". Well, heck, if I don't have 'em, nobody does! So,
is there a way around that?

How do I find out what the security settings are? Passwords, etc. I really
am the ONLY one who's been diddling with this thing, so what now? I can't
even blame an employee, unfortunately. All on me.

Is there some way to import all the forms, queries, etc into a new database
and start fresh? The reason I ask that is I've tried to do that (new
database, different name, and File/Get External Data/Import, etc. It copies
everything fine, the forms are there, the queries, etc. But no code. All
the code for each form is empty and inaccessible.

Help!
ron - in a world of hurt!
May 2 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Ron
Have tentatively determined my problems below may stem from a lousy initial
install of Access. If I copy my program over to another machine (this one
with Access2003) and make a new database, I can import my forms and get the
code along with them. I just can't on my main machine.

So, it appears my solution is to copy programs/data, etc over to another
machine, uninstall Access 2000 completely on main machine, and reinstall.
Then, copy them back. I'll assume for now that'll solve the "no code"
problem below. If it doesn't, then I'll punt.

So, can anyway tell me how to make sure I delete all of Access2000 before
reinstalling? Any tricks to it to make sure it's completely gone (this
being windows and all... ::grin::)

TIA
ron

"Ron" <ro*******************@earthlink.com> wrote in message
news:TH****************@newsread3.news.pas.earthli nk.net...
Hi All,

First question is what to do if somehow security was run on a database
I've designed and yet I have NO idea how or when it was run? There is a
"system1.mdw" file sitting there, and I think it's been there since day
one when I started playing around with Access 2000 back a couple years
ago. Any way to circumvent the security settings? Cancel the settings so
they aren't even there (as, I don't need them anyway...)?

The reason I ask, is that I started using Tony Toew's Auto FE Updater and
was having problems due to "security settings" which was a real surprise.
When starting database on the 2nd machine it was saying I didn't have the
"necessary permissions". Well, heck, if I don't have 'em, nobody does!
So, is there a way around that?

How do I find out what the security settings are? Passwords, etc. I
really am the ONLY one who's been diddling with this thing, so what now?
I can't even blame an employee, unfortunately. All on me.

Is there some way to import all the forms, queries, etc into a new
database and start fresh? The reason I ask that is I've tried to do that
(new database, different name, and File/Get External Data/Import, etc. It
copies everything fine, the forms are there, the queries, etc. But no
code. All the code for each form is empty and inaccessible.

Help!
ron - in a world of hurt!

May 3 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.