Search results

I'm linking to the oracle tables using my vb application where i'm using tabledef to create a equallent oracle table in ms access.DAO will take care of creating tables in ms access using msjet engine. FYi Dim tdf As TableDef tdf.SourceTableName="xxx"(this is oracle table)...

Thanks for our reply. Yes, MS Access will convert into text if it can't hold that big numeric.In my case that is not the reason as i can see numeric data in ms access as well. Is there any other reason? Hope i'm clear in explaining my problem, if not let me know. Ramesh

Hi, Can anybody help me ? I've a case where ms access displays oracle's numeric field as text where msaccess is linked to oracle.The possible reason could be when we don't specify precision in declaring the filed in oracle table, default precision is 38 which ms access cannot hold. So...

Can we break the connection string and I want to use only some part of the connection string, can we? The connection string is as follows: ODBC;DRIVER={Oracle in...

Hi, I found the reason to my problem, but need help in solving this problem.How to break the connection string of Linkeddatabase table in MSAccess. To get the connection string of Linked database table we use the following syntax Database.tabledef("Tablename").Connect The above connect...

Thanks for reply. The problem occurs at times not always and its with connection string. Is there is any way to aviod this by reducing the connection string. Ramesh

Sorry, it is ReportDb.TableDef.Append tdf before this we link connect to the ODBC database using tdf.Connect property the code looks as follows tdf.connect=con_str tdf.Sourcetablename=tname ReportDb.TableDef.Append tdf where reportdb is Database object of jet Engine,TableDef is Table...

the problem occurs when we say ReportDb.Append tabledef where ReportDb is Dabase object. Ramesh

Hi All, I'm new to this group and new to access also. I come across an error message "Connection string is too Long" while creating tabledef in Access using VB. The actual procedure is to create a linked tables of Oracle in Access in locally and use the mdb fr report generation. In...

Hi All, I'm new to this group and new to access also. I come across an error message "Connection string is too Long" while creating tabledef in Access using VB. The actual procedure is to create a linked tables of Oracle in Access in locally and use the mdb fr report generation. In...