I need to remove and re-establish a Machine Data Source in Access.

M

Mike Labosh

I need to remove and re-establish a Machine Data Source in Access...how?

1. Start -> Settings -> Control Panel -> Administrative Tools -> Data
Sources

You can remove your machine data source from there, reconfigure it, or
create a new one.

2. In Access, from the database window, use the tools menu to find the
Linked Table Manager. That will help you refresh your linked tables to the
correct Machine Data Source

--
Peace & happy computing,

Mike Labosh, MCSD

"Mr. McKittrick, after very careful consideration, I have
come to the conclusion that this new system SUCKS!"
~~ General Barringer ~~
 
T

Tony Toews

twolguy said:
I need to remove and re-establish a Machine Data Source in Access...how?
Click to expand...

Assuming that a Machine Data Source and DSNs are similar I'd suggest
going DSNless.

I much prefer DSN-Less connections as it is one less thing for someone
to have to configure and one less thing for the users to screw up.
This is also better for Citrix/TS farms where each individual system
would have to have a DSN created and maintained.

Using DSN-Less Connections
http://members.rogers.com/douglas.j.steele/DSNLessLinks.html
ODBC DSN-Less Connection Tutorial Part I
http://www.amazecreations.com/datafast/GetFile.aspx?file=ODBCTutor01.htm&Article=true
HOWTO: Use "DSN-Less" ODBC Connections with RDO and DAO
http://support.microsoft.com/?id=147875
ODBC DSN Less
http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Top