×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Access .MDB unknown Owner - Sql Migration

Access .MDB unknown Owner - Sql Migration

Access .MDB unknown Owner - Sql Migration

(OP)
Hi,

I am trying to migrate a series of older .mdb databases to Sql. The Long term goal is to eventually upgrade the whole suite of tools to powerapps.
One of the databases has all but two of its tables owned by (unknown). The system .mdw Admin has no permissions on any of those tables and there is no other .mdw file stored with the databases.

Is there anyway to take ownership of the tables within the database? Or a way to clear the permissions so the Access SQL migration tools can access the data stored with the database?

Thank you!

RE: Access .MDB unknown Owner - Sql Migration

Either the default admin user has both read data and read design permission on the tables or not. If it can, simply import the table to a new file as admin. The new file will not have any permissions on it unless you have set it up in the database to inherit it - at least I think you could... Old deprecated feature, my memory is fuzzy.

If not, how do you know the tables exists? I'd go down that path... likely there is a workgroup somewhere that you can get at that some user has access to in some way... If you can use that user permission and the workgroup to import to a file where that user is logged in but also admin or All Users has access to the objects, you can do another cycle after to import as admin...

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close