restoring user profile to another user (copying profile)

I came across a problem related to some tweaks/settings in MS Office, OCX registration etc.. Older users (profiles) on Windows 2003 TS have no problem opening databases in MS Access, new user names can't open them due to misconfiguration. all users are connecting via RDP with 2003 TS.

Is there a way to duplicate 'old_user' profile to 'new_user' including local profile and registry settings? I can't get it to work since most of required changes were never documented, it'll take really long time trying to find out what needs to be set.

Appreciate any help.
LVL 5
CoffinatedAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Sid_FCommented:
What is the error message you receive when you try to open them and is there any corresponding errors in event viewer?
0
CoffinatedAuthor Commented:
The error message is related to OCX (discontinued product) it is 100% related to MS Access DB. there are several settings which no longer can be replicated. I am hoping to use one of the working profiles for new users.
0
Sid_FCommented:
Is it possible that this is simply a permissions issue, new users need to be added into a specific group? Check working user profiles, do they have an odbc connection configured?
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

atsvirginiaCommented:
To copy a user profile, please perform the following:

1. Open System Properties.

2. On the Advanced tab, under User Profiles, click Settings.

3. Under Profiles stored on this computer, click the user profile you want to copy, then click Copy To.

4. Specify where the new profile will be saved

5. In "Copy profile to", type the location for the new profile, OR click Browse to select the path.

6. Specify who is permitted to use the copied profile

7. In Permitted to use, click Change.

8. In the Select User or Group dialog box, in Enter the object name to select, add the user, group, or built-in security principle or click Object Types to select an object type.

9. To specify a domain to search, in the Select User or Group dialog box, click Locations, and then select the domain.

10. To further narrow your search, in the Select User or Group dialog box, click Advanced.

11. Click OK
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Sid_FCommented:
In my opinion its worth investing time in finding the root cause of the problem as copying the profile is putting a plaster on the problem and extra work each time you add a new user.
0
CoffinatedAuthor Commented:
Problem solved, the answer I was looking for was provide by "atsvirginia" however copying a profile didn't work so I was forced to investigate it further therefore taking "Sid_F's" suggestion.
The problem was not with the profile itself since all settings on TS were applied to all users. The problem was related with a way some user names/passwords were created in the database. Recreating them in MS Access fixed the problem.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2003

From novice to tech pro — start learning today.