Attain and Microsoft Access

balrog

Hello,
my problem is that I want to connect a table in Access database with a table in Navision database. I need to know if it is possible, what utility I need to do it and so on. Can anyone help me?

nunomaia

Can you define better connect .

Sbhat

Hi,

You will have to use CFRONT to do this.

Thanks
Best regards
Suresh.

Luc_VanDyck

When you use C/ODBC, you can create a "Linked table" in Access. This "Linked table" is just a reference to the table in Navision. When you open the table in Access, it gets the data, through ODBC, from the Navision database.

Is this what you want?

Denis_Petrov

Hi,

I would just convert Access file to .csv and then do dataport.

balrog

nunomaia wrote:

Can you define better connect .

Hi,

I`ll give a better definition of my problem. I need a table inside Access, which shows actual data from Attain table No. 27 - Item and I need this table to be related with another table inside Access. In present time I do it by exporting data to Excel Sheet. Then I import it to Access, but I have to do it once a day, and from time to time, some problems may occur.

Can you give me an advice? Thanks a lot.

balrog

Luc Van Dyck wrote:

When you use C/ODBC, you can create a "Linked table" in Access. This "Linked table" is just a reference to the table in Navision. When you open the table in Access, it gets the data, through ODBC, from the Navision database.

Is this what you want?

Hi,

that really could be what I`m looking for. Can you give me some more information about C/ODBC? How can I use it? What do I need to use it? And in the end, will I be able to make relation between this linked table and another table inside Access?

Thanks a lot.

shogan@mila.ie

Hi Balrog

I do what you are looking for, using C/ODBC.

C/ODBC extends the Data Sources (ODBC) in the Control Panel in Windows.

I use Attain 3.01A. On the product CD, there is a CODBC folder. Run setup from here and follow instructions.

In the ODBC Control Panel, Add a new System DSN (this works better than File DSN).

The driver you will be using is C/ODBC 32 Bit. Set it up to work from your database (I have a server connection). Make sure you logon with admin rights, so that you have access to all tables!

Then in Access, create a new Database.

File - Get External Data - Import (or link...depends on your choice, I would recommend Import, as it is safer!)

Change 'Files of type' at the bottom of the dialog box to 'ODBC Databases'.

Click on 'Machine Data Source', and select the connection you just created, and wait for your company selection to appear.

Just a note - I have found that you cannot switch companies until you shut down access and reopen the db you created initially.

Hope this helps!

Stephen H.