Windows 7 problem with odbc 1

[jpl458]

Have an existing application written in Access 2003 and XP. Got a new computer that has Windows 7, and i loaded Office 2003 on the new machine until I get Office 10 in the future. The Access application is using linked tables to SQL Server 2008 R2 Express.
My problem is that when I create a System DSN everthing goes fine, and the test connection is successful and i am able to select tables from SQL Server and tey appear in the Tables list in the application. But when I try to run the application on the new machine and use the link table manager the ODBC name is not displayed in the Machine Data Source window where it used to be. If I select new is says I don't have administrative Privilages and can't create or remove DSN.

Any help would be appreciated

Thanks in advance

jpl

 

[dhookom]

Can you create and use a User DSN rather than System?

Duane
Hook'D on Access
MS Access MVP

 

[jpl458]

Yes, and the problem is it asks me for a file name to keep the User DSN in, and I don't know if thers is a specific file for this or should I creat one, and if so where is the best place to keep it (best practice)

I am also wondering, and have looked into, what I would have to do to get admin priviladges. I've read some stuff and it looks dangerous. One article says that Windows 7 comes with no administrator assigned, or words to that effect, and that i can reate a new one. But that sounds odd because anyone could do that so where is the security. Not an expert on Windows internals.

Thanks for the response.

jpl

 

[dhookom]

I'm not sure on Windows 7 but in Vista when creating a DSN I see tabs for User DSN, System DSN, and File DSN. I can go all the way through creating a User DSN without any prompt for a file name.


Duane
Hook'D on Access
MS Access MVP

 

[jpl458]

Well I did it yur way and it worked. the problem I was having had to do with where the DSN name was showing up when I wanted to link the tables. It was in the Machine Data Sources window. When I found that I worked slicker n' snot.

Thanks for pointing me there.

jpl