How can i create a table contain more than 255 filed in MS Access?

[Hy Chanhan]

Dear, I need you to help: I want to creat a table contain more than 255 field,but in MS Accesss it support only 255. so how can i create? Hy Chanhan

[Guffa]

Why on earth would you need more than 255 fields? It sounds as your database design is seriously flawed...

--- b { font-weight: normal; }

[Eric Dahlvang]

stutter[^] :laugh:

--EricDV Sig--------- Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them. - Laurence J. Peters

[Guffa]

There is a small difference between the threads. One is about Access and the other about MySQL.

--- b { font-weight: normal; }

[Hy Chanhan]

Just want to know, it can or cannot?

[Guffa]

It can not. Microsoft Access specifications[^]

--- b { font-weight: normal; }

[Hy Chanhan]

Thank Guffa for giving me some idea

[eggsovereasy]

My brain hurts just thinking about it!

[Hy Chanhan]

Don't think, no way to do this, because Microsoft limit only 255 in MS ACCESS