473,714 Members | 2,531 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Conversion from 2.0 to 2000: Admin has no Administer rights on forms

Hi all.

I'm having a problem that's driving me nuts. I am not familiar with
Access, but I have read the FAQ, searched google, read the Access
Security FAQ, and looked at the Access Web, to no avail. Briefly, the
problem is this:

I'm having an old Access 2.0 database that I want to convert to Access
2000 on a different computer. The reason why the new database is on a
different computer is that the old database runs under Windows 95a (no
kidding!) on a 300 MHz Celeron with 32 MB of RAM. The disk has about 50
Megs of free space. I don't want to try to install Access 2000 on that
machine. :-) The database is split into several MDB files, a few of
which contain only tables, but one of which contains all the forms and
VBA code.

I can convert the data-containing tables just fine, no problems there.
However, the forms-containing tables give me problems. Access 2000 told
me that I needed a lot of permissions simply to open the database. I
have joined the workgroup, using the original workgroup file. The
workgroup admin tells me that I have joined the workgroup successfully,
but I still get the error message.

I'd very much like to make a new workgroup file, but no-one knows the
values for the WID etc of the original workgroup file, and I wouldn't
know how to recover them from that file.

My next try was to try to "de-secure" the database as per the Access
Security FAQ. That means granting all permissions to the Users group and
the Admin account, putting Admin back in Administrators, removing its
password, and (optionally) transfer ownership to Admin.

The Admin user is in the Admins group. As far as I can see, the owner of
the forms is listed as "<Unknown>" , and the Administer rights have been
revoked from the Administrator. (In fact, no user or group has
Administer rights.) When I try to add these rights back, the form that
appears tells me that the "current user" is "Administrator" , but for
some reason, I get a "permission denied" error when I try to give
Administer rights to the Administrator user or the Administrators group.
I also can't transfer the ownership, which fails with a similar
message. (I have also looked to make sure that the current user is not
in fact "Administra tor " with a trailing space or something, but
apparently this is not the case.)

All the above user and group information is translated from German. The
Admin is "Administra tor" and the Admins group is "Administratore n".

I have only one System.mda file (*not* a .mdw file), but I don't really
know whether this is the one that's being used. Everything that I did
seems to be consistent with that assumption, though, and I have found no
..ini file that told me otherwise.

The forms, unfortunately, together with their associated VBA, contain a
lot of business logic, so recreating the forms and macros from scratch
is out of the question. I'd be happy, though, if I could somehow recover
the forms and VBA code through some kind of "save as" feature.

Please help me. Otherwise, I'll either jump out of the window or tear
all my hair out :-)

Oh yes, and happy Nikolaus to you all :-) (Is that known outside Germany?)

Stephan
--
Stephan Neuhaus
ADC IT-Security GmbH - 66111 Saarbrücken

Nov 12 '05 #1
1 1790
Stephan Neuhaus wrote:
Hi all.


I've experimented a bit. Importing the database objects into a new
database did the trick. The objects are now unsecured and I can
manipulate them at will.

Fun,

Stephan
--
Stephan Neuhaus
University of the Saarland, Department of Computer Science
Experimental Software Security at the Chair of Software Engineering
Web: http://www.st.cs.uni-sb.de/~neuhaus

Nov 12 '05 #2

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

Similar topics

1
1844
by: Perttu Pulkkinen | last post by:
Hi all freaks! I have been thinking hard, what would be good solution for a straight-forward content management. I want to forget polls and forms etc.. and concentrate first only on different kinds of pages. I came up with this approach in "nightly vision", wich felt very flexible. ADMIN FORMS **************
12
2810
by: Google Mike | last post by:
You know, while working on my moonlight corporation's LAMP project at home this weekend, I couldn't help but wonder if people writing similar projects are solving similar problems with having to complete the project by building an installer and building the user/group administration piece of it. The thought came to me that it would be great if LAMP developers, whether they used MySQL or PostgreSQL, could just simply write the project to...
5
10241
by: Raj | last post by:
Hi, I'm a newbie with SQL Server 2000 Developer. I know that it is supposed to install on Windows XP Pro, but I keep running into the following message: "The logon account cannot be validated for the SQL Server service. Validate ...". I've looked for help and taken the advise of trying the user
7
1303
by: James R | last post by:
I am a retailer whose software back-end has just been upgraded from Access to SQL Server 2000. (The front-end is an independently-written shop Point Of Sale system) While I know a fair bit about computers, I know nothing about SQL Server. And frankly, I don't want to know much. I don't need to build any new databases, program SQL, or "be an administrator". All I need to know about is how to go into the raw data like I did in Access and...
12
3051
by: Arno R | last post by:
Hi there, I just distributed an application in which I (try to) change db.properties depending on CurrentUser() For instance I set the property's AllowBypassKey and AllowBuiltinToolbars to False when CurrentUser() <> "xx" I just noticed that the property's can only be changed changed by a user belonging to 'Admins'. I never noticed this before. I could swear that in other apps (A97) this works fine without the user being an admin... ...
1
1646
by: Siobhan Perricone | last post by:
We're trying to convert the last Access 97 database in our department to Access 2000. The database is secured, and the problem is that the database owner hasn't worked for the department for years. So his account has been gone for a while, and the database no longer has an actual owner. We have a couple of administrative accounts, and they've been able to do what was needed to this point, but there are two tables over which we can't...
3
1575
by: Richard Hallgren | last post by:
Hi, I have a project that uses Crystal Reports (VS .Net included) and the System.Data namespace. I've managed to deploy the project and to get Crystal Report working on my clients XP based machines. However, once I try the install the solution on their Win 2000 machines I run into some problems. On some machines the application works but the Crystal Report engine throws an error, on other machines the applications crashes (with the...
5
1733
by: RedEye | last post by:
Hello, I am working on a test site to explore the new login controls and membership features of ASP.NET v2.0. I have tested the controls using SQL Express and have now decided to try using a central SQL Server 2000 database. When I use the all of the included controls with SQL Express everything works great but when I use it against SQL Server 2000 I can't get past the login page. When in Visual Studio IDE and open the web admin page I...
8
2783
by: aklein | last post by:
I was given a database to update and am running into the following problem: The database appears to have been secured using Access security (it is an MDB, not MDE). Every form etc that I try to open (in the development environment) gives me 2 messages: 1) "You do not have exclusive access to the database at this time etc." 2) "You don't have permission to read frmWhatever... etc."
0
8796
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8704
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
9307
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...
0
9170
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
6627
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
4462
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...
0
4715
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2514
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2105
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.