Exchange record info between two Access dbs

[JohnPapa]

Gemma-the-husky,

I only need to transfer basic info, like name, address, medical history.

The goal is for the sending dentist to click a button, which would generate a file that he can email to the other dentist, who would click one button and import the data in his db.

Sounds simple but as you mention, there are lurking problems when dealing with multiple languages.

Thanks,
John

 

[DCrake]

As a matter of interest what happens if you do the following

Dim sStr As String

sStr = Cstr(Me!memMedicalHistory)

print #1, sstr

 

[JohnPapa]

DCrake,

Tried what you suggested, same problem. I also tried function strConv and setting to the default Code Page.

The more I think about it, it appears that the only fullproof way is to do the transfer using an mdb or mde containing a single table.

John

 

[DCrake]

Ok So I went to Bing translator and translated some English text into Greek then copied the Greek into a table. I then exported the table to Excel. When I opened the table in Excel the language was preserved. So you may need to look at using an Excel file as your middle ware. Have only tried it with Greek so if you have issues with other languages experiment with them first.

 

[JohnPapa]

Excel should work and I have used it extensively in conjunction with Access. If you use late binding, it would be independent of the version of Excel. The reason why I did not opt for Excel is the possibility that the user does not have Excel. May be a good idea after all.

Thanks for reminding me of its existence,
John

 

[JohnPapa]

It is now working. I can pass record details in any language from an Access db to another Access db. The procedure is as follows:
EXPORT
1) Click on an Export button which opens up a form asking for the pathname of the mdb or mde to be created.
2) Create the mdb using CreateDatabase(strFullPathname, "tblCustomerIE") This creates the db from scratch with the required fields.
3) Create the link to the mdb and copy the values of the fields you want.
IMPORT
1) Click on an Import button which opens up a form asking for the pathname of the mdb file.
2) Create the link to the mdb.
3) Copy the required fields
Thanks to all and happy Thanksgiving,
John

 

[Dairy Farmer]

Glad to see that works. I guess that the best way to transfer data from one DB to another is to use a DB file. That way it doesn't matter what language you are using.

Remember to add the following:

Backup procedure before export
Empty export file before export
Delete record from source after backup and export

Backup procedure before import
Check duplicates before import
Empty import file after import