Access

[mshot]

I would like to be able to view my ES companies in MS Access. Can someone help me do this?

 

[dgillz]

ES is a SQL database. Just set up an ODBC connection to the database(s). Once you are able to "view" them, what do you want to do?

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[mshot]

I want to be able to view the live data as entered. At a previous job I was able to view all tables in Access and I found it much easier to maintain the tables.

 

[dgillz]

OK did you try the ODBC connection?

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[mshot]

How do I get it from Enterprise Manager to an ODBC connection? I apologize for not replying sooner.

 

[mshot]

I got it!

 

[dgillz]

Just curious, but what is it that you want to maintain that is easier with Access?

Anything maintenance-wise you can do with Access you can do a lot easier, and better, with Enterprise Manager. Plus there is a roll-back option (undo) that can be a lifesaver in SQL query analyzer.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[mshot]

I was taught how to view the data with Access. While I learn through Enterprise Manager, I'd like to be able to see it the way I'm used to for comparison.