troubleshooting Question

How To: Query as Record Source > 255 Fields ?

Avatar of n8dog
n8dog asked on
Microsoft Access
17 Comments2 Solutions298 ViewsLast Modified:
** PERSONAL WEBSITE DOMAIN & has NOTHING TO DO WITH this PRJ or the COMPANY I WORK FOR **

DB FILE >> http://n8dog.com/TMDB_ONLINE_SND.jpg  
  *((CHANGE THE EXTENSION from JPG to MDB once DL'd))

---------- DB File ----------

1.) Multiple tables exist. These various tables are for testing purposes of diff. attempts to solve the 480 Field barrier issue.

2.) Multiple Forms exist as well, for the same reasons as above.

3.) All sensitive data has been extracted from the tables due to obvious security reasons.

The current barrier is the 255 Field Query barrier.

Having this DB should make it a great deal easier discussing potential solutions.


I am looking to solve for the 255 Field Limit for the Query as a Record Source, while/or Solve the "Iterative" example that has Helper Functions like the Duplicator and Incrementor's on the Sample Forms.

Please contact so we can discuss. I am open to solves. I don't care about "most normalized" solution, just one that works for this data storing purpose.

-n8D

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 17 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 17 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros