Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Linked tables to SQL Server
0 views
Skip to first unread message
Weste
Nov 13, 2007, 4:41:02 PM11/13/07
to
I have Access 2003 and Access 2007 on my pc. I am using Access 2003 and am
trying to connect to a database in SQL Express. I have created a System DSN
and successfully tested the connection. However, when I select File | Get
External Data | Link Tables | Files of Type = ODBC Databases, the ODBC
Datasource Administrator does not appear. The link tables dialog just
disappears. Does anyone know of any issues with running 2003 and 2007 on
the same pc?
trying to connect to a database in SQL Express. I have created a System DSN
and successfully tested the connection. However, when I select File | Get
External Data | Link Tables | Files of Type = ODBC Databases, the ODBC
Datasource Administrator does not appear. The link tables dialog just
disappears. Does anyone know of any issues with running 2003 and 2007 on
the same pc?
Also when I switch between versions, the installer always runs to configure
the version of Access I am opening. This is a pain. Is there a way to stop
this?
Thanks for your help.
Rick Brandt
Nov 13, 2007, 7:52:51 PM11/13/07
to
Believe it or not it is likely your anti-virus software. I don't recall the
specifics (someone else might chime in), but if you search these groups you
should find the setting that needs to be changed.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Weste
Nov 14, 2007, 2:26:01 PM11/14/07
to
Wow I never would have guessed that. I turned off the office plug-in for
Norton and that fixed the problem. Thank you very much!
Norton and that fixed the problem. Thank you very much!
0 new messages