How do I translate an Access file with Trados 6.5?
Thread poster: Eugenia Strazzolini

Eugenia Strazzolini  Identity Verified
Canada
Local time: 02:25
English to Spanish
+ ...
Nov 15, 2004

I've been assigned a translation under these instructions:
This job MUST be completed in MS Aceess Database 4.0. Please send me clean Access files and uncl;ean Trados files and your invoice.
Can anybody help me????


Direct link Reply with quote
 

Ralf Lemster  Identity Verified
Germany
Local time: 08:25
English to German
+ ...
Ask you customer... Nov 15, 2004

Hi Eugenia,
To the best of my knowledge, MS Access is not supported by Trados. The only workaround I can think of is to export tables form Access to MS Excel, and to use TagEditor on the Excel sheets. This is something you should definitely discuss with your customer - TBH this doesn't sound as if there were really familiar with Trados...

Best regards,
Ralf


Direct link Reply with quote
 

Jerzy Czopik  Identity Verified
Germany
Local time: 08:25
Member (2003)
Polish to German
+ ...
No way to translate Access with Trados Nov 15, 2004

I asked Trados support this question allready. The answer was no, and it will remain no. This is because Access is a database software, with not only text, but switches and so on.
Exporting to Excel may help, however not allways, this depends on the strukcture of Access tables.

The other possibility is to mark text and use T-Window for Clipboard. This is the way I would go.

OTOH delivering an UNCLEANED Access file is impossible.
What you ca deliver is clean translated Access file and probably the Trados TM.

Against my usual attitude to giving discounts I would never give any discount on Access and set my price approx. 25% higher as usuall. Access can be very tricky...

Regards
Jerzy


Direct link Reply with quote
 

mónica alfonso  Identity Verified
Local time: 04:25
Member (2004)
English to Spanish
+ ...
Some time ago I had to translate a loooooong database in Access Nov 15, 2004

I cut and pasted the table in Word and it worked OK.
Then you have to clean with Trados and paste the translated table in Access.
Probably your client will have to get the uncleaned version in Word and the cleaned one in Access.
Of course I agree with our colleagues: ask you client and make clear that Trados does not work in Access itself.
Regards and good luck.


Direct link Reply with quote
 

Eugenia Strazzolini  Identity Verified
Canada
Local time: 02:25
English to Spanish
+ ...
TOPIC STARTER
Thank you vefry much to all of you Nov 15, 2004

When I asked how to do it, the client answered "Access 97 SR-2", which left me even more lost thatn at the begining.

Thank you very much for your help and for confirming I'm not an idiot.

Eugenia


Direct link Reply with quote
 

Jerzy Czopik  Identity Verified
Germany
Local time: 08:25
Member (2003)
Polish to German
+ ...
This simply means Nov 15, 2004

Eugenia Strazzolini wrote:

When I asked how to do it, the client answered "Access 97 SR-2", which left me even more lost thatn at the begining.

Thank you very much for your help and for confirming I'm not an idiot.

Eugenia


that if anyone here is an idiot, this are not you.
Acces 97 SR-2 means Acces 97 (from Office 97) with installed Service Release 2 (today called Service Pack).
You will really need to have this particular version of Access, as the compatibility between different versions (Access 97/2000/XP) is not very good.
And nevertheless, either Access without SR nor Access with SR can be translated in direct way with Trados.

Regards
Jerzy


Direct link Reply with quote
 

Eugenia Strazzolini  Identity Verified
Canada
Local time: 02:25
English to Spanish
+ ...
TOPIC STARTER
Thank you Jerzy! Nov 15, 2004

Nice to know.

Direct link Reply with quote
 
xxxBrandis
Local time: 08:25
English to German
+ ...
ask your out sourcer the following Nov 15, 2004

Eugenia Strazzolini wrote:

Nice to know.
extract the database tables and send you. Because Access has a jet at the back, and it is normally organized in an interconnected manner called VBA project.These files are not easy to process unless they are singled out as tables which you can export to excel and process in a TagEditor of Trados. After finishing go back to access and reimport the translated files and delete the original tables ( they are marked as 1 the originals ) and 2 is the replica.As you remove the 1 the 2 needs renaming without numbering. Send a command and join the tables, you have your fully translated Database. That is a lot of work. So if your outsourcer is paying only for the translation part, either he doesn´t know the work involved or he is well knowledged to pay only this. In any case I suggest without pre-entertaining the right thoughts along these lines and some work experience on single table based (multiple queries!1 Watch out, table names, their links KEYS may fool)Generally any database with 10 Tables in development area falls under Designing (programming) category, priced around €45,- hourly rate for the beginner on the german market, an experienced hand might get, mind you with good arguments around €75,-. Keeping all the above mentioned aspects in mind, you should now be able to accomplish this project. You cannot send unclean Access file, instead you are prepared to send unclean tables, yes this is possible. Just now posted a how to here:
http://www.proz.com/howto/208 , doesn´t cover the forms and queries.
Good luck
Brandis

[Edited at 2004-11-15 23:20]

[Edited at 2004-11-15 23:32]

[Edited at 2004-11-16 10:13]


Direct link Reply with quote
 

Eugenia Strazzolini  Identity Verified
Canada
Local time: 02:25
English to Spanish
+ ...
TOPIC STARTER
Hey! Nov 15, 2004

That's a good tip! Thank you.

Direct link Reply with quote
 
xxxBrandis
Local time: 08:25
English to German
+ ...
Thank you Nov 15, 2004

Eugenia Strazzolini wrote:

That's a good tip! Thank you.
Next would be how to process look up tables in a Database using Trados. But that has time.Good luck
Brandis


Direct link Reply with quote
 

Hynek Palatin  Identity Verified
Czech Republic
Local time: 08:25
English to Czech
+ ...
Translating Access database with Trados Nov 16, 2004

First you need to find out what exactly should be translated. Access databases contain not only database tables, but also forms, reports, etc.

The only way to translate forms and reports with Trados is using T-Window for Clipboard, because it's not possible to export these objects to an editable format.

To translate database tables, you can:
- Use T-Window for Clipboard. That would be a pretty hard work and you wouldn't be able to produce any uncleaned file.
- Copy and paste the table(s) to Word, translate and paste back as Mónica suggests. This should work with small tables, but be careful when pasting back.
- Export the tables, translate and import back. IMO this is the best solution, but requires some technical knowledge and should be paid extra. I wouldn't export the tables to Excel, because Excel has some limitations on text length and that could be a problem if the database contained long memo fields. (But Excel might be OK in some cases.) I would probably use CSV format and translate it in Word, maybe with some preprocessing.

Anyway, your client probably doesn't understand what he is asking you to do.


Direct link Reply with quote
 

Fernando Toledo  Identity Verified
Germany
Local time: 08:25
German to Spanish
It is not possible to work... Nov 16, 2004

...with Excel?

Simply open the files to be translated in Excel and translate it using a CAT (Trados, DVX, SDLX).

Open the access file direct in Excel save as xls, translate it with TE, save it bilingual (uncleaned) and cleaned as xls, then in Access impot Data (clean Access).

Am I missing something? where is the problem?
The primary keys can/should not be translated

Rgds

[Edited at 2004-11-16 12:04]

[Edited at 2004-11-16 12:04]


Direct link Reply with quote
 

RWSTranslation
Germany
Local time: 08:25
Member (2007)
German to English
+ ...
Missing ? Nov 16, 2004

Toledo wrote:

....

Am I missing something? where is the problem?
The primary keys can/should not be translated

Rgds


Hello,

what is with forms, reports and other programming code ?

With kind regards

Hans


Direct link Reply with quote
 

Robert Tucker
United Kingdom
Local time: 07:25
German to English
+ ...
Microsoft Access Translator Nov 16, 2004

what is with forms, reports and other programming code ?

Browsing net found:

http://c85.cemi.rssi.ru/access/Downloads/Trans/Trans.asp

It's only for Access 97 and 2000 (but 4.0 is over 10 years old ??!!)


Direct link Reply with quote
 
xxxBrandis
Local time: 08:25
English to German
+ ...
also possible Nov 17, 2004

DSC wrote:

Toledo wrote:

....

Am I missing something? where is the problem?
The primary keys can/should not be translated

Rgds


Hello,

what is with forms, reports and other programming code ?

With kind regards

Hans
This is a different type of work, hence I personally need to see the database first, before continuing here.
Regards,
Brandis


Direct link Reply with quote
 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

How do I translate an Access file with Trados 6.5?

Advanced search







TM-Town
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »
SDL MultiTerm 2017
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2017 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2017 you can automatically create term lists from your existing documentation to save time.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search