Link to home
Create AccountLog in
Avatar of SheahaST
SheahaST

asked on

Cannot link to SQL Server Express 2008 table from within Access 2007

I am running on Windows Vista Ultimate 64bit.  Access 2007 is a 32 bit application.  SQL Server Express 2008 is a 32bit application.  I have created DSN "MEBCallCenter" that tests correctly in "Control Panel\Administrative Tools\Data Sources (ODBC)\System DSN".  In Access "External Data\More\ODBC Database\"  I select "Link to the data source by creating a linked table."   The "Select Data Source" dialog's tab "Machine Data Source" does not contain this DSN.  If I try to create a DSN from this dialog I receive the following message "You are logged on with non-Administrative privileges.  System DSNs could not be created or modified."  I am the administrator for this machine.  This worked on a 32 bit version of Windows Vista Home Premium Edition.
Avatar of SheahaST
SheahaST

ASKER

I turned off User Account Control in "Control Panel\User Accounts\" and rebooted the system.  This allowed me to do the above, but is there a safer way to do this for only Access 2007?

Thanks in advance.
Not sure about Vista but the latter SPs in XP created a similar security structure.  Just a guess, but maybe it has something to do with Internet/Intranet Local Zone security.  I've had to add local intranet references to get by some of the security stuff.  Just a shot in the dark, :-)

-a
ASKER CERTIFIED SOLUTION
Avatar of SheahaST
SheahaST

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account