Predecessors

[GusGG]

Hi,
I am developing an Access table (extracted from larger DB) to be imported
into Project.

In developing this table I am also identifying the "Predecessors" required
in Project for subordinate tasks. Since I have MANY tasks on the order of 2
to 3K tasks per project I am running into problems storing the precedent id's
in a VB Array. I do not want to write directly to an Access table, due to
speed limitations.

Is there a way to declare the VB array to hold information greater than 256
characters in length, i.e., a Memo field??

Thanks in advance for any input,
Gus

 

[doniy]

to store predecessor information, you need field of ID, Predecessor ID, lag
type, lag time, you need only 13 bytes for each record

a string can hold up to about 65400 or 2 billion bytes,if you use VB on a
typical computer runnig windows.

 

[GusGG]

Thank you for your reply.
I resolved my problem from tne VBA board. It seems that the data was in
deed inthe array. It was simply my method of viewing the data (diplaying the
cell in break mode) was clipping the text to 256.

Thnks again for your input.
Gus