473,287 Members | 1,927 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,287 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
--
Stephan Neuhaus
ADC IT-Security GmbH - 66111 Saarbrücken

Nov 12 '05 #1
1 1777
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
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...
12
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...
5
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...
7
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...
12
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...
1
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...
3
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...
5
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...
8
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...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
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: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
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)...

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.