Silly Question...

[msuryadarma]

Ok, this is simple, but I dunno how to do it.

I'm using Access 97 importing data from SQL servers using ODBC connection.

You know I have to add new Machine Data Source right? Well I did, and it all went fine. The problem is, I named it wrong.

All I want to do is rename the freakin' server connection so that under Machine Data Source tab, under the Data Source Name and Description, I can have the correct name.

For example, my Data Source Name is "Employee", all I wanna do is change it to "Corporate Employee". That's IT, it doesn't even have anything to do with the database. But I can't find a way to do it!! There's only a "New" button in that window, there is no "Edit" button. Damn it. Pisses me off because of something simple like this.

Can anyone help? Thanks a lot!

Martin

[Ianpbaker]

what O/S Are you using, becuase on mine WIN95 and most of the others you have the configure button, which let's you go through and change the option's you have already set up

Ian

[Ianpbaker]

Sorry msuryadarma I'm looking at this in the wrong way.
When you use the select datasource window in access, it only let's you add new one's like you said. Go into control panel and look for the ODBC Datasources icon and double click on it. From within there you can find the datasource you made, click on configure and change what ever you like with it

hope this helps

ian

[msuryadarma]

Ian, thanks so much. That's what I want to do. Damnit, why can't they make it simpler?

Thanks again!!

Martin