473,750 Members | 2,451 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 2431
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.md b /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\m saccess.exe"
"c:\program files\Rides\Rid es.mdb"
/wrkgrp "c:\Program Files\Rides\Rid es.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
"Campbellbr ian" <ca************ ***@yahoo.com> wrote in message
news:e3******** *************** ***@posting.goo gle.com...
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.
"Campbellbr ian" <ca************ ***@yahoo.com> wrote in message
news:e3******** *************** ***@posting.goo gle.com...
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************ @mindREMOVEspri ng.com> wrote in message
news:BK******** ********@newsre ad2.news.atl.ea rthlink.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.
"Campbellbr ian" <ca************ ***@yahoo.com> wrote in message
news:e3******** *************** ***@posting.goo gle.com...
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**********@n ewsreaderm1.cor e.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********@bwa y.net.invalid> wrote in message
news:94******** *************** ****@24.168.128 .90...
te*********@mps .co.uk (Terry Kreft) wrote in
<bl**********@n ewsreaderm1.cor e.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
2652
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, but I would like to have all the office apps on the same version. So I have a few questions: 1) Is the file format the same as 2002? Can 2002 users read 2003 files? 2) What are the major reasons for upgrading to 2002 ?
1
5750
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 same as it was in Access 2002? I am running Access 2002 at the moment. Is there any reason for testing purposes etc, for me to purchase Access 2003 if I am going to recompile the Access 97 mdb files into Access 2000 format mde files which...
3
2125
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 Access 2002 in order to run it do you? Thanks!
7
3463
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." Interestingly I can open the mdb files of the same 2003 databases in Access 2002 without problems. To my understanding the file formats of 2002 and 2003 are the same and this problem shouldn't exist. And why is it only the mde files that are giving the...
6
4751
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 appreciated. Thanks in advance
9
2882
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 data. I find this tolerable. The Access 2002 test version, on the network, takes approximately 50
2
1779
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 familiar with those books. Does anyone have a recommendation? TIA.
52
9980
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 2005, and, since he already has licenses for Office Pro 2002, he wants to upgrade to that. I've been saying that we need to upgrade to Access 2003, not 2002, even if Office is kept at 2002. We are also looking to do a fair amount of...
0
2757
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 product) to install my applications. When the Access Runtime was needed on the system I simply ran 'accessrt.msi' from Microsoft Office Developer discs. When another version of Access (other than Access 2002) was on the system then I simply...
0
8840
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9584
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
9345
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9259
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8266
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6817
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6083
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
2
2811
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2228
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.