Can't Add a linked table to SQL Server 2005 with Access 2003

Hi,

I have an Access 2003 front end that contains a number of linked tables on SQL Server 2005 SE. I recreated the application on a second network for testing and was able to use the Linked Table Manager to refresh the database connections. The problem is when I try and add another linked table. I select Link Tables from the menu and then when I select 'ODBC Databases()' from the 'Files of Type' list box, the Link window closes right away.

Any suggestions?

I would post to MS Access newsgroups to get help on this, sounds like a problem with Microsoft Access ->

http://www.microsoft.com/office/community/en-us/default.mspx

My only feeble guess for you is that somehow ODBC is not installed correctly on the computer, try re-installing latest MDAC.

|||if you are running Norton AV , turn off the Office Plug in, Anti-virus/Options/Misc|||You can't modify tables in access 2003 against SQL 2005. I use access 2007 beta with good results.|||

I was having the same problem as bonkers1963 and I found this posting. I have Norton AV and the Office Plugin option was set on. I turned off the Office Plugin option and restared Access then I could link tables with no problem.

Thanks for the info.

Can't Add a linked table to SQL Server 2005 with Access 2003

Hi,

I have an Access 2003 front end that contains a number of linked tables on SQL Server 2005 SE. I recreated the application on a second network for testing and was able to use the Linked Table Manager to refresh the database connections. The problem is when I try and add another linked table. I select Link Tables from the menu and then when I select 'ODBC Databases()' from the 'Files of Type' list box, the Link window closes right away.

Any suggestions?

I would post to MS Access newsgroups to get help on this, sounds like a problem with Microsoft Access ->

http://www.microsoft.com/office/community/en-us/default.mspx

My only feeble guess for you is that somehow ODBC is not installed correctly on the computer, try re-installing latest MDAC.

|||if you are running Norton AV , turn off the Office Plug in, Anti-virus/Options/Misc|||You can't modify tables in access 2003 against SQL 2005. I use access 2007 beta with good results.|||

I was having the same problem as bonkers1963 and I found this posting. I have Norton AV and the Office Plugin option was set on. I turned off the Office Plugin option and restared Access then I could link tables with no problem.

Thanks for the info.

sql

cannot see second drive??

I am running an SQL database on a win2000 server with SQL 2000 and all updat
ed service packs. I have a database that I would like to move to a second dr
ive on the same server. When I look into the database (properties\database l
ocations) I cannot see the
second drive, only the drive that SQL is installed on. The second drive is f
ormatted and data is on it already but I cannot see it when I use the browse
button from the above location. How do I see this second drive? Thanks in a
dvance for any help on thisVerify that the account that SQL Server starts under has full control of
the root of the drive. If the local system account is being used then make
sure the SYSTEM acount ahs full control.
Rand
This posting is provided "as is" with no warranties and confers no rights.

cannot see second drive??

I am running an SQL database on a win2000 server with SQL 2000 and all updated service packs. I have a database that I would like to move to a second drive on the same server. When I look into the database (properties\database locations) I cannot see the second drive, only the drive that SQL is installed on. The second drive is formatted and data is on it already but I cannot see it when I use the browse button from the above location. How do I see this second drive? Thanks in advance for any help on this
LVerify that the account that SQL Server starts under has full control of
the root of the drive. If the local system account is being used then make
sure the SYSTEM acount ahs full control.
Rand
This posting is provided "as is" with no warranties and confers no rights.

cannot see second drive??

I am running an SQL database on a win2000 server with SQL 2000 and all updated service packs. I have a database that I would like to move to a second drive on the same server. When I look into the database (properties\database locations) I cannot see the
second drive, only the drive that SQL is installed on. The second drive is formatted and data is on it already but I cannot see it when I use the browse button from the above location. How do I see this second drive? Thanks in advance for any help on this
Verify that the account that SQL Server starts under has full control of
the root of the drive. If the local system account is being used then make
sure the SYSTEM acount ahs full control.
Rand
This posting is provided "as is" with no warranties and confers no rights.