Error when adding a System DSN

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to add a system DSN for Visual Foxpro driver. When I attempt to
add it I get a message stating "could not write to registry" Then Datasource
then shows that its there but when I search the registry there is no key
installed. I am running Office XP on Windows XP pro
 
Hi, Jason.
I am trying to add a system DSN for Visual Foxpro driver. When I attempt to
add it I get a message stating "could not write to registry"
Click to expand...

Make sure that you have Windows Administrator permissions on the computer
that you are trying to add the System DSN to. Make sure that the
Administrator isn't locked out of this bank of Windows Registry Keys, too.
(Use Regedt32.exe to set security permissions for the Windows Registry.)

Also, make sure that you have the latest version of MDAC installed on your
computer. You might as well make sure that you have the latest service pack
for Jet 4.0 while you're at it, even if you aren't currently using Access.

You may need to install MDAC 2.5 first to get all of the components needed
if and only if your OS is prior to Windows 2K. Get MDAC 2.8 SP-1 here:

http://msdn.microsoft.com/data/mdac/downloads/default.aspx

Get Jet 4.0 SP-8 here:

http://msdn.microsoft.com/data/downloads/updates/default.aspx#Jet

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that questions
answered the quickest are often from those who have a history of rewarding
the contributors who have taken the time to answer questions correctly.
 
Thank you for your response. When I log in as an administrator I do not have
this problem. I am however trying to install this DSN for a member of a
domain and I think thats where the permissions are getting screwed up. I
have made this user a member of administrators for the purpose of getting
this done with no luck. I will see if the 2 upgrades you suggested work.
 
Hi, Jason.
When I log in as an administrator I do not have
this problem. . . .
I
have made this user a member of administrators for the purpose of getting
this done with no luck. I will see if the 2 upgrades you suggested work.
Click to expand...

I still recommend that you have the latest service packs installed on this
workstation, but the fact that the Administrator account can create a System
DSN when a member of the Administrators cannot means that sufficient files
are already on the computer, but the Administrators Group does not have
sufficient Windows security permissions to carry out the task.

At the risk of sounding redundant, make sure that the user is a member of
the workstation's Administrators Group. Being a member of the Domain
Administrator's Group doesn't count in this situation because their Windows
security permissions can be configured independently from this particular
workstation.

If this is already the case, then you need to contact your Windows System
Administrator to give sufficient permissions to the workstation's
Administrators Group, because this workstation wasn't configured correctly.
(Unless, of course, it's your organization's policy to shackle the
workstation Administrators Group from doing ordinary system tasks, which is
unwise from an organizational management standpoint where wasted time is a
_whole_ lot of money.)

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that questions
answered the quickest are often from those who have a history of rewarding
the contributors who have taken the time to answer questions correctly.
 
Back
Top