Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 11th, 2003, 05:30 PM
Registered User
 
Join Date: Dec 2003
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Field limit and linked tables

Scenario:
I have an oracle table that has about 400 fields in it. I only need the information in about 5 of the fields.

However, if I set up the table as a linked ODBC table in access, it only shows me the first 255 fields, in *alphabetical order.* I know that access 2002 has a field limit of 255, but is there a way to change *which* fields Access 2002 pulls from the odbc link? One of the 5 fields I need is alphabetically after the first 255. (starts with a v)

Thanks
1
 
Old December 11th, 2003, 05:32 PM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

In Oracle create a view of which fields you need, then link to that view.

Regards,

Beth M
 
Old December 11th, 2003, 05:43 PM
Registered User
 
Join Date: Dec 2003
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I'd already thought of that, but it will take about 3 weeks of paperwork/approval before they'd be willing to add the view. (corporate processes are a pain) Right now, I'm stuck with the existing tables/views.

Thanks
 
Old December 11th, 2003, 05:45 PM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

What about ADO and only go after the fields you need, and forget linking through ODBC?
Beth M
 
Old December 11th, 2003, 06:35 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 308
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I think Beth could be onto something here -
If you can query the database, rather than link to it, you might be able to get around the problem.

Steven

I am a loud man with a very large hat. This means I am in charge





Similar Threads
Thread Thread Starter Forum Replies Last Post
Linked Tables edojan Access 1 July 20th, 2006 10:49 AM
Getting data from linked tables SoC Classic ASP Databases 2 October 13th, 2005 08:18 PM
Linked Tables ru1 Access 1 September 21st, 2005 07:24 AM
help with two linked tables query footohi Access 2 August 25th, 2005 10:25 AM
Linked Tables ricmar Access VBA 6 July 28th, 2004 05:08 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.