Field captions

[voiD]

Hello,

I have an MS SQL 2000 backend, and I link the tables from here to an .mdb file. In that .mdb I would like to change the field captions of the tables in runtime, but when I try to assign value to a caption property which didn't have value before, I receive an error message which says, that this property could not be found. I tried out a lot of things, but up to now, without any success. Does anybody have any idea, what could be the solution?
I would be very grateful for any small tips!

Many thanks,
voiD

 

[boblarson]

I don't believe that you can do this with linked SQL tables. You can rename the tables themselves as it sets an alias for the actual table name, but as for modifying any fields within that table that would be not allowed by SQL Server.

So, you'll have to change the field names when creating your queries, which you can do, so the field names are what you want in your forms and reports.

 

[voiD]

the solution ;-)

Not a long time after I've posted my question, I had found out the answer also. The solution was very simple: When the error, which says that this property could not be found, occures, I have to create a user defined property, called Caption, for the given field and then assign to this the desired caption.

Many thanks for the tip boblarson, but it not so good in my case, because it is important to keep the original fieldnames.

VoiD