When I use the code bellow, I got next error:
The Microsoft jet database engine stopped the process because you and another user are attempting to change the same data at the same time.
Error appears when I try to open the recordset (query) in last line of code.
I work with application and database (they are separated) localy on one machine, so no one else can access the table at that time.
DoCmd.RunSQL "DELETE * FROM BAZASKLA"
DoCmd.TransferText acImportDelim, "BAZASKLA_Import_Spec", "BAZASKLA", "C:\APPEIP\PROMET\BAZASKLA.txt"
Set rsPrepisani = baza.OpenRecordset("SELECT BAZASKLA.* FROM BAZASKLA INNER JOIN BAZASKLAD ON BAZASKLA.OS_LIST = BAZASKLAD.OS_LIST", dbOpenDynaset)