importing objects from secured database to clean database

[Jaye7]

I have an access database that was set with security about 10 years ago.
I have now created another database in 2010 and I am importing all the objects to make a clean non secured database.

When I import tables it imports system table objects like MSysRelationships, but as it already exists it adds another MSysRelationships with a 1 on the end (MSysRelationships1).

Should I delete the original MSysRelationships and then rename the MSysRelationships1 as MSysRelationships.

There are numerous others like MSysAccessstorage, MSysACEs etc...

I am gathering that if I don't rename MSysRelationships1to MSysRelationships then the relationship data would be incorrect and the database wouldn't work correctly, but maybe I am wrong.

 

[vbaInet]

That's interesting Jaye7. I wouldn't have expected a system table to get imported.

When you hide system objects do those extra tables get hidden? Need to confirm if they're system tables or are now normal tables.

Also, have you tried copying and pasting instead of importing?

 

[Jaye7]

They are definitely system tables, they are not hidden as I use the UsysRibbons table to add ribbons etc... and then hide it.
I haven't tried copying and pasting, but will try it.

My main concern is the relationships though, if I don't import the system table MSysRelationships will that cause problems in my database, or should I not import any system tables other than the UsysRibbon that I use?

 

[vbaInet]

Alright, I thought you were saying that you didn't import those objects but they got there somehow. You don't need to import the system tables.

Access should handle the relationships if you click "Options >>" and tick the Relationships checkbox. Obviously, test that and make sure it does.

 

[Jaye7]

That's great, I was worried if I didn't import certain objects that it could cause problems.

I tried the copy and paste but it was a bit annoying as I first had to select each object (over 300 objects) and then each time it tried to paste a linked table I got a popup message to copy as linked or data only etc... then I had an error on 1 table and nothing else copied, whereas importing I didn't get any errors.

Thanks for your help

 

[vbaInet]

No, you should be fine. Access will rebuild the relationships and any other system objects as long as you tell it to do so.

Do you remember what sort of error you received? And whether it was a normal or linked table?

If you ever want to do a copy and paste, you can use Ctrl+A and that will select all the objects in the Objects pane, then the usual Ctrl+C, Ctrl+V. And if you want to deselect certain objects hold down Ctrl whilst clicking the item and it will be deselected.

 

[Jaye7]

I tried ctrl+A, shift+ctrl+end, arrow down etc... but it doesn't select them all, My Access version is 2010.

Shortcut keys are enabled as I can use F11 etc...

The error message was for a linked table, it seems that it has been removed from the Back end but not from the front ends and I do get the error message when using the import also.

In importing you don't get the message whether you want the linked table imported as linked or local etc... for each linked table.

 

[vbaInet]

Quite right, I forgot that it doesn't. What you can do is click the first object, scroll down to the last item (don't click yet), hold down Shift then click the last item.

Ah ok, nothing to worry about then.

 

[Jaye7]

Thanks for all your help, much appreciated.

 

[vbaInet]

You're welcome!