secure access 2.0 database that needs to be converted to access 20

From: Edward Letendre (EdwardLetendre_at_discussions.microsoft.com)
Date: 02/28/05 

Date: Mon, 28 Feb 2005 14:43:05 -0800

Okay, I have a bit of a trickly situation.

I think I mentioned this before, but did not get a good answer that solves
my problem. The database was created long before I started at the company.

Basically the database was created in access 2.0 to store customer data and
sales data. The tables were created under the administrator user id from
what I can tell. Various user accounts were created to input and or update
information.

The database was then opened and used in an access 97 database. However the
access 2.0 database was never converted from an access 2.0 database to an
access 97 database. I tried to open the database in access 97 in exclusive
mode, but I get an error saying that you don't have the permission to do so.

I opened the database back in access 2.0 and I was able to access the
database as it was, no errors or anything. I tried to add the permission to
open the database exclusively to the existing or orginal database as it was
created, but I don't have the permission to do this even in access 2.0.

As I said before, the database was created as admin, or administrator,
either which id I could not figure out the password. Is there a way to
switch the owner's of the tables and or the database so I can get access to
the database and be able to open it exclusively in access 97 and evenutally
into access 2000 so I can convert the entire database from access 2.0 to
access 97 or even access 2000.

In either case, I need to log in as the correct database owner and grant
open exclusively (is this correct). How can I get around the password
situation?

What else can I do to make sure that I can log in and grant the permissions?
 Could I add a user to the admin group? Any answers would be of help.

Edward Letendre.

Relevant Pages

  • Re: T-SQL Debugger Error
    ... denied on object 'sp_sdidebug', database 'master', owner 'dbo'. ... and when I grant the permission of sp_sdidebug, ... I am using following statement to grant the permission. ...
    (comp.databases.ms-sqlserver)
  • RE: Security context of stored procedure
    ... Suppose there are three users in a database TEST_CHAIN, ... simple stored procedure: ... also grant it to test_sp2 ... SELECT permission denied on object 'authors', database 'test_chain', owner ...
    (microsoft.public.sqlserver.security)
  • Re: GRANT BACKUP DATABASE
    ... I grant to one user the permission to backup one database but now i cant ...
    (microsoft.public.sqlserver.server)
  • Re: code access security
    ... Error 1 CREATE ASSEMBLY for assembly 'GmsSqlClr' failed because assembly ... owner has EXTERNAL ACCESS ASSEMBLY permission and the database has the ... make sure the database owner is mapped to the correct login on ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: low permission cannot convert from A97 to A2000/2003
    ... Delete is a separate permission. ... You need open exclusive permission on the database to ... > The admin user has full privileges. ... > as we wont be importing those files from them, and the contractor will be ...
    (microsoft.public.access.conversion)
Loading