472,378 Members | 1,352 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

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 "Administrator " 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 "Administrator" and the Admins group is "Administratoren".

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 Neuhaus
ADC IT-Security GmbH - 66111 Saarbrücken

Nov 12 '05 #1
1 1730
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.


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

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...
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...
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...
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...
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...
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...
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...
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...
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...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge required to effectively administer and manage Oracle...
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the synthesis of my design into a bitstream, not the C++...
by: Ricardo de Mila | last post by:
Dear people, good afternoon... I have a form in msAccess with lots of controls and a specific routine must be triggered if the mouse_down event happens in any control. Than I need to discover what...
by: Johno34 | last post by:
I have this click event on my form. It speaks to a Datasheet Subform Private Sub Command260_Click() Dim r As DAO.Recordset Set r = Form_frmABCD.Form.RecordsetClone r.MoveFirst Do If...
by: ezappsrUS | last post by:
Hi, I wonder if someone knows where I am going wrong below. I have a continuous form and two labels where only one would be visible depending on the checkbox being checked or not. Below is the...
by: jack2019x | last post by:
hello, Is there code or static lib for hook swapchain present? I wanna hook dxgi swapchain present for dx11 and dx9.
by: DizelArs | last post by:
Hi all) Faced with a problem, element.click() event doesn't work in Safari browser. Tried various tricks like emulating touch event through a function: let clickEvent = new Event('click', {...
by: F22F35 | last post by:
I am a newbie to Access (most programming for that matter). I need help in creating an Access database that keeps the history of each user in a database. For example, a user might have lesson 1 sent...

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.