Problem with MS Access 97 database security

jliebman

All,

I recently started at a company that has a number of older MS Access
97 database applications that support production and order
fulfillment. There is one database with which I have the following
problems:

1) no one can make modifications to the database except by logging in
using the database creator's userid and password on the workstation
used by that person, who has of course left the company. Anyone else
who tries to access the database, even the system administrator, gets
the message "You dont have the nececssary permissions to use the
xxxxxxxxx object.Have your system administrator or the person who
created the object establish the appropriate permissions for you."

2) We logged in and "added" another person with the same permissions
as the creator for all database objects, except we did not change the
database object "ownerships ", and the problem still persists. I
suspect that the ownerships are the problem. Is this so?

3) I dont know anything about the restriction to a particular machine.
Can anyone enlighten me on this issue?

TIA

JL

Apr 19 '07 #1

Subscribe Reply

1954

Keith Wilby

<jl******@kjlso ftware.comwrote in message
news:11******** **************@ e65g2000hsc.goo glegroups.com.. .

All,

I recently started at a company that has a number of older MS Access
97 database applications that support production and order
fulfillment. There is one database with which I have the following
problems:

1) no one can make modifications to the database except by logging in
using the database creator's userid and password on the workstation
used by that person, who has of course left the company. Anyone else
who tries to access the database, even the system administrator, gets
the message "You dont have the nececssary permissions to use the
xxxxxxxxx object.Have your system administrator or the person who
created the object establish the appropriate permissions for you."

2) We logged in and "added" another person with the same permissions
as the creator for all database objects, except we did not change the
database object "ownerships ", and the problem still persists. I
suspect that the ownerships are the problem. Is this so?

3) I dont know anything about the restriction to a particular machine.
Can anyone enlighten me on this issue?

TIA

JL

It sounds like the workgroup file (*.mdw) is on that user's PC. As a
general rule of thumb I don't give accounts the names of individuals but of
functions, eg "developer" could be the admin name, a member of the Admins
group.

Things to (consider) do(ing):

1 - MAKE A BACKUP.

2 - Log in on the original developer's account. Create a generic
"developer" account and give it full permissions to everything including the
database object.

3 - Log in on the new account and create a new blank database. Import all
of the objects from the "old" database. The new account should be the
owner. You should then be able to make design changes with this account.

4 - Put the workgroup file on a server where all users can access it.

5 - Split the db and put the back end in the same location as the workgroup
file. Give all users their own local front end copy linked to the back end.

6 - Have the users launch the app using a desktop shortcut using the
"/wrkgrp" command line switch. That way they will not be prompted for a
password for "unsecured" apps.

I think that's all ... hope it helps.

Keith.
www.keithwilby.com

Apr 19 '07 #2

Similar topics

4421

How Can I List Tables in a DB?

by: Wayne Wengert | last post by:

I am using VS.NET 2003, VB.NET, ADO.NET and an Access 2000 database. I want to display a list of all tables in an Access database. I want to put that list of table names in a listbox so the user can select the table they want to use. How can I do this? -- ------------------------------------ Wayne Wengert wayne@wengert.org

.NET Framework

4243

Connection problem from Access front end application to SQL Desktop Engine backend

by: Barb | last post by:

Hi there, I sincerely hope that someone out there can help. I have two instances of the SQL 2000 Desktop Engine running. One is on my local machine for development and the other is on another machine on our network which is the production environment. I have built an Access 2003 front end application which connects to this database. This works fine locally, as you would expect. I successfully installed the database on the...

Microsoft SQL Server

1744

Read only database problem

by: Al Jans | last post by:

Hi, I have a multi-user access 2k database, with a server based backend and a local machine based front end. What I want is : 1) one group of users to have a full access (i.e. edit, delete, insert etc data) into the system via the front end with no restrictions 2) one group of users to have read only access on the data via the front end

Microsoft Access / VBA

2587

Blocking users from accessing Access database

by: kai | last post by:

Hi, All I try to block some one import my Access database tables using Access database. I used password protection, but if some one crack through my password, are there any other methods to block some one importing my tables using Access database? Thanks

Microsoft Access / VBA

2974

Compacting access database problem

by: lappy | last post by:

Hello, I have written a small programme to compact an access 97 database. Dim je As New JRO.JetEngine ' Compacts database Data.Mdb to Data2.mdb. je.CompactDatabase "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=C:\Dump\DataOld.Mdb", _ "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=C:\Dump\Data.Mdb"

Microsoft Access / VBA

2200

Problem connecting to Access Database from ASP.NET Application

by: Nathan Sokalski | last post by:

I am trying to connect to a Microsoft Access Database from my ASP.NET Application. I use the following code to create my connection string: cmdSelect.Connection = New System.Data.OleDb.OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATASOURCE=" & Server.MapPath("/WebApplication1/nathansokalski_com.mdb")) Although the error does not occur until the Fill() method is called:

ASP.NET

7571

Problem connecting to password protected Access file

by: kthiagar | last post by:

Hi I am trying to connect to a password protected access file from VB.NET. I have no problem in connecting to Access, if I remove the password. This is what I am doing: In the server explorer, I choose "Add a connection" Choose "Microsoft Jet 4.0 OLEDB Provider" in the provider tab Selected the access file in the next tab Left Username as Admin and typed the password. Now when I try to test connection, I am getting this error message:

Visual Basic .NET

9989

Access 2002 vs. 2003

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...

Microsoft Access / VBA

1502

Authentication problem continued

by: SAL | last post by:

Hello, I'm still having trouble getting my app to authenticate correctly. I have read the tips at: http://www.devhood.com/messages/message_view-2.aspx?thread_id=72204 and am still having trouble making this happen correctly. Here are my settings. SQL Server 2005 db access is required Web page Anonymous access is turned off in IIS.

ASP.NET

2237

security problem with ms-access?

by: novak | last post by:

hi list, since a couple of weeks we face a special "security" problem. neraly every ms-access database that is located on our net-drives cannot be opened. when clicking the document's icon, first, the warning message arises "open document - security message" - "Really open *.mdb ....?", second, when clicking "start" ms-access starts, but the mdb-file cannot be opened. message: "ms-access could not open the file ... The

Microsoft Access / VBA

9519

Changing the language in Windows 10

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,...

Windows Server

10436

Problem With Comparison Operator <=> in G++

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...

C / C++

10163

The easy way to turn off automatic updates for Windows 10/11

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,...

Windows Server

10000

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

9040

AI Job Threat for Devs

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...

Career Advice

7538

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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...

Microsoft Access / VBA

5436

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5563

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2920

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General