Recent content by jhkinter

Thks so much for your answer, by database password on back end, someone still can import link table from front end with no password needed and got data finally. Another point is database password hv third party program to recover. Now i found the way frm some forums and below is coding just to...

I set my table on server and front end with table link on user machine with vba log in code. However someone still can make blank database and import my table from server and table link from front end. I user this code to hide table on server, and it's work (cannot see through Tool>Show...

Thks so much David, it's work ! Now I can fix length as needed for every field.

I have to upload my Access Data to Oracle Core System. They need .txt with field length fixed for uploding format. I fix length by this function in query: - Trans Amount: Right(String(17," ") & [TETHB],17) - for number Currency: Right(String(3," ") & [THB],3) - for text Once I export with...