473,326 Members | 2,588 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Access 2002 Conflicting Access 97

I have a database that I thought had fairly tight security applied to
it. It's in Access97. I'm running it also on a couple of machines that
shipped with Access 2002. This is probably not a good idea, but to
avoid rewriting the application I put A97 on the new machines and
setup my usual wrkgadm.exe to the .mdw that everyone else was using.
However when a user opens Access 2002 it wipes out the directive to
the .mdw and they can then open the 97 application with no security
prompts.
Any ideas?
Thanks! Brian
Nov 12 '05 #1
7 2412
On 29 Sep 2003 14:16:17 -0700, ca***************@yahoo.com
(Campbellbrian) wrote:

Don't change the default workgroup file. That's rude anyway.
Rather, use a shortcut to run your app:
<path to>msaccess.exe <path to>myprogram.mdb /wrkgrp <path to my mdw>

-Tom.

I have a database that I thought had fairly tight security applied to
it. It's in Access97. I'm running it also on a couple of machines that
shipped with Access 2002. This is probably not a good idea, but to
avoid rewriting the application I put A97 on the new machines and
setup my usual wrkgadm.exe to the .mdw that everyone else was using.
However when a user opens Access 2002 it wipes out the directive to
the .mdw and they can then open the 97 application with no security
prompts.
Any ideas?
Thanks! Brian


Nov 12 '05 #2
First, if your users can create their own security file, or use a different
security file and then get into your palpations, then you don't have any
security at all do you?

If you have implemented security correctly, then the users will NOT be able
to get into the file unless they use YOUR security file. In fact, even if
your users where to create their own workgroup file, and add some users THEY
STILL CAN NOT GET into your file. If your users by accidentally using a
different workgroup file can get into your application then you HAVE NOT set
security correctly. If you have security set correctly, and you loose your
workgroup file, you CAN NOT get into the application. Something is wrong,a
and you have not implement security correctly.

Now, assuming you eventuality fix the above, then next problem is to fix the
security workgroup file setting when running a97, and running a2002. You
should ALWAYS give the users a short cut with the workgroup file set for
your database. (as mentioned, if they don't use your workgroup file, they
SHOULD be locked out. (since this is NOT the case, you as mentioned DO NOT
have security implement correctly).

At any rate, the advantage of setting the workgroup file in the shortcut is
that other access applications thus don't have to use, or even care about
YOUR workgroup file (you don't even have to bother setting, or joining the
workgroup file if you specify the workgroup file in your shortcut. And, as
mentioned, if they try and launch the mde file directly, they will NOT be
able to run it (thus, they will quickly learn they must use the shortcut
your provide). You can specify what workgroup file is to be used the in the
shortcut. It will look like:

"C:\Program Files\Microsoft Office\Office\msaccess.exe"
"c:\program files\Rides\Rides.mdb"
/wrkgrp "c:\Program Files\Rides\Rides.mdw"

You also need to download the security faq, and figure out what step you
missed, but for sure if users can get into your application with a different
workgroup file, then you don't have any security at all do you? When
security is setup correctly, you MUST use the correct workgroup file, or all
users will be locked out. And, as mentioned, even if a user creates THEIR
OWN new workgroup file, they STILL CAN NOT get in.

so, check out the security faq:

http://support.microsoft.com/default.aspx?scid=kb;[LN];207793
--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
ka****@msn.com
http://www.attcanada.net/~kallal.msn

Nov 12 '05 #3

You do not have a secured application if users can get into it using a
different workgroup file.

First get the Access Security White paper and apply it to your application
so that it is really secure.
Second use the command line which runs your app to point to the correct
workgroup file.

Terry
"Campbellbrian" <ca***************@yahoo.com> wrote in message
news:e3**************************@posting.google.c om...
I have a database that I thought had fairly tight security applied to
it. It's in Access97. I'm running it also on a couple of machines that
shipped with Access 2002. This is probably not a good idea, but to
avoid rewriting the application I put A97 on the new machines and
setup my usual wrkgadm.exe to the .mdw that everyone else was using.
However when a user opens Access 2002 it wipes out the directive to
the .mdw and they can then open the 97 application with no security
prompts.
Any ideas?
Thanks! Brian

Nov 12 '05 #4
TR
To add to what the others have said, you almost certainly have not
implemented security properly. The two most obvious oversights are:
You have not removed all permissions from the default Users group.
You have not passworded the default admin user in your workgroup.
You have not removed the admin user from the admins group.

Ok, that was three oversights.
"Campbellbrian" <ca***************@yahoo.com> wrote in message
news:e3**************************@posting.google.c om...
I have a database that I thought had fairly tight security applied to
it. It's in Access97. I'm running it also on a couple of machines that
shipped with Access 2002. This is probably not a good idea, but to
avoid rewriting the application I put A97 on the new machines and
setup my usual wrkgadm.exe to the .mdw that everyone else was using.
However when a user opens Access 2002 it wipes out the directive to
the .mdw and they can then open the 97 application with no security
prompts.
Any ideas?
Thanks! Brian

Nov 12 '05 #5
I think there's a law that you're allowed one oversight when pointing out
other peoples oversights.<g>.

Terry
"TR" <tr************@mindREMOVEspring.com> wrote in message
news:BK****************@newsread2.news.atl.earthli nk.net...
To add to what the others have said, you almost certainly have not
implemented security properly. The two most obvious oversights are:
You have not removed all permissions from the default Users group.
You have not passworded the default admin user in your workgroup.
You have not removed the admin user from the admins group.

Ok, that was three oversights.
"Campbellbrian" <ca***************@yahoo.com> wrote in message
news:e3**************************@posting.google.c om...
I have a database that I thought had fairly tight security applied to
it. It's in Access97. I'm running it also on a couple of machines that
shipped with Access 2002. This is probably not a good idea, but to
avoid rewriting the application I put A97 on the new machines and
setup my usual wrkgadm.exe to the .mdw that everyone else was using.
However when a user opens Access 2002 it wipes out the directive to
the .mdw and they can then open the 97 application with no security
prompts.
Any ideas?
Thanks! Brian


Nov 12 '05 #6
te*********@mps.co.uk (Terry Kreft) wrote in
<bl**********@newsreaderm1.core.theplanet.net>:
I think there's a law that you're allowed one oversight when
pointing out other peoples oversights.<g>.


I think the law is that whenever you point out oversights by
someone else, you'll make one mistake yourself in the process.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 12 '05 #7
That's the one, hence my mistake.

Terry

"David W. Fenton" <dX********@bway.net.invalid> wrote in message
news:94***************************@24.168.128.90.. .
te*********@mps.co.uk (Terry Kreft) wrote in
<bl**********@newsreaderm1.core.theplanet.net>:
I think there's a law that you're allowed one oversight when
pointing out other peoples oversights.<g>.


I think the law is that whenever you point out oversights by
someone else, you'll make one mistake yourself in the process.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

Nov 12 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

13
by: Noesis Strategy | last post by:
When I ordered my new laptop, Sony didn't offer Access 2003 in its bundles. Recently, I have begun to design Access databases using an copy of Access 2002 from my previous laptop. It works fine,...
1
by: Wayne Aprato | last post by:
I have a client who is running several Access 97 databases that I have written for them. They are about to upgrade to Access 2003. Is the default file format of Access 2003 still Access 2000 the...
3
by: Scott | last post by:
Hi, If we want to compile an Access 2002 database and distribute it to others, will the compiled software run on any PC, like Windows 98, Windows 2000, etc. Also, you don't have to have...
7
by: Wayne Aprato | last post by:
I have several Access 2003 mde databases. When I try to open them in Access 2002 I get the following error: "The Visual Basic for Applications project in the database is corrupt." ...
6
by: Peter Frost | last post by:
Please help I don't know if this is possible but what I would really like to do is to use On Error Goto to capture the code that is being executed when an error occurs. Any help would be much...
9
by: Rob | last post by:
Scenario: O/S: Win XP Professional Back-end: Access 2002 on network server I have an Access 97 application, in production on our network, that takes appoximately 5 minutes to process monthly...
2
by: Bruce Dodds | last post by:
I will be doing an app for a nonprofit. It would be useful for them to have a good entry-level book on Access so that they don't have to pay someone to design all their queries and reports. I'm not...
52
by: Neil | last post by:
We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server at the same time. We're moving to SQL Server...
0
by: Sebastian | last post by:
Hello I develop my applications in Access 2002. My development system is running Windows XP SP2 and I have Microsoft Office XP Developer. Microsoft Office XP is at SP3. I used Inno Setup (great...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.