ISTech Support Forum - Linking Access and DBA using Crystal

Welcome, Guest. Please Login.

	04/27/24 at 15:42:13 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Crystal Reports, ODBC & Access › Crystal Reports General Issues

‹ Previous topic | Next topic ›

Pages: 1

Linking Access and DBA using Crystal (Read 1579 times)

kurt

Browser

Posts: 3
Gender: male

Linking Access and DBA using Crystal
03/12/03 at 11:53:59

Does anyone have experience with linking DBA and Access number fields?

I am linking BKARINVL using the SO# (BKARINVL_BKAR_INVL_INVNM) to a number field in an Access database (Office XP) and they don't want to work. I noticed that the DBA number field length is 6 which doesn't have an equivalent in Access.

Any ideas on how to do this? I keep the status of the sales orders in the access database and bring them together when generating the report..... ???

IP Logged

aricon Active Member Systems Consulting-See website for products! Posts: 1283 Gender:	Re: Linking Access and DBA using Crystal Reply #1 - 03/12/03 at 12:32:24 Don't quite understand the field length comment. Myself and my VB/Access programmer have done quite a bit of linkage to DBA and not sure exactly what you mean here.
Back to top	Sincerely, Lorne Rogers President Aria Consulting & Implementers Ltd. Phone: (780) 471-1430 Fax: (780) 471-4918 E-mail: lrogers@ariaconsulting.net IP Logged

kurt

Browser

Posts: 3
Gender: male

Re: Linking Access and DBA using Crystal
Reply #2 - 03/12/03 at 15:27:47

Sorry for the lack of clarity.

When I attempt to link the DBA table with the Access table I receive the following message " File link Warning. The specified fields may not link successfully due to different type." I have formatted the Access field with every possible version of Number format available and I always receive this message.

When I do a Priint file layout for the BKARINVL field in question is says that is is a number that is 6 bytes long (I am assuming!) undecided

IP Logged

aricon

Active Member

Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male

Re: Linking Access and DBA using Crystal
Reply #3 - 03/12/03 at 16:09:39

OK, so you are trying to directly link a DBA table to your Access table.....

1st thing is that in general this is not a good practice. Second thing is that it is not 6 bytes long it is 6 characters long.

I can try to help you out with this a bit tomorrow, but I can only allot a reasonable amount of time until it moves into an area where I have to charge for it.

It IS my business after all undecided

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net

IP Logged

Lynn_Pantic Ex Member	Re: Linking Access and DBA using Crystal Reply #4 - 03/12/03 at 16:18:12 The BKAR_INVL_INVNM field in DBA is actually an Integer which is a different type of data element than a numeric field.
Back to top	IP Logged

Pages: 1

ISTech Support Forum › Crystal Reports, ODBC & Access › Crystal Reports General Issues

‹ Previous topic | Next topic ›